I only know Python, but you can explain for another language, I’ll try to figure it out. The challenge is that there is an excel file available online that includes most of the members of this group. This file has 30 columns and 11 rows. From time to time in the announcement file of events that I attend as an assistant organizer. But the thing is, seats are limited, usually 1 or 2 and I almost always miss.
I want to write a program that when using say 10-11 lines in one column automatically fits my name in the 12th line of that column.
How can I do this, what tools do I need to use?
So you have a MS Excel sheet, and you want to write a program to automatically modify it. However excel format is proprietary so you cannot really make a non-excel program edit an excel sheet as far as I know. (plus the owner of the sheet would not allow it?)
Perhaps there is a way to do it via C# but I’m not familiar with the MS OS features that would allow that type of sheet edit.
Excel has the ability to create macros that run against the sheets and modify them though, but not sure if that is what you wanted.
1 Like
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.