Dear all,
How can i read a excel file as input, then select only some wanted coulums and rows for this file and again save it as excel file.
Hope to let help from you all.
Sincerely,
Monoj Sharma Luitel
BHUTAN
Dear all,
How can i read a excel file as input, then select only some wanted coulums and rows for this file and again save it as excel file.
Hope to let help from you all.
Sincerely,
Monoj Sharma Luitel
BHUTAN
Microsoft .xls files are a proprietary file format, which means you need one of these options:
Or perhaps take an easier approach and get excel to save the file as a .csv file, which you then process to yield another .csv file for import back into excel. CSV files are just text files, which are very easy to process from a C program.
I believe the really new versions of excel also use XML as a text format for saving files, with the advantage that all the formatting information is also preserved as well. It too is easy to parse from a C program.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.