How do you read a spreadsheet file in python or c# and copy specific cells, rows and columns to a new spreadsheet file | Sololearn: Learn to code for FREE!
Neuer Kurs! Jeder Programmierer sollte generative KI lernen!
Kostenlose Lektion ausprobieren
0

How do you read a spreadsheet file in python or c# and copy specific cells, rows and columns to a new spreadsheet file

manipulation of spreadsheets in python or C#

28th Mar 2017, 9:41 PM
Albert
Albert - avatar
4 Antworten
+ 5
python-excel.org offers some packages you might find useful
28th Mar 2017, 9:54 PM
Mario L.
Mario L. - avatar
+ 5
You may use openpyxl which is fairly straightforward and supports .xlsx extension. Check out my example: https://code.sololearn.com/cGcw92Q6ZUjB/#py
28th Mar 2017, 10:06 PM
Kuba Siekierzyński
Kuba Siekierzyński - avatar
+ 1
Open an Excel spreadsheet file in notepad You'll find out it's easy to convert its content into a 2D array
28th Mar 2017, 9:44 PM
Arsham Khashabi
0
Thank you guys, I googled it and it's easier if I convert the file to csv formart then each cell will be identified by a comma, making it easy to manipulate
28th Mar 2017, 10:01 PM
Albert
Albert - avatar