Hello I want to write a program in c++ to convert certain rows which i can choose from a table in excel to .csv. Anyone done anything similar? I am not sure how to do this, still thinking, any suggestions.
rudasi -2 Light Poster
iamthwee
Assuming there is a reason you don't just want to open the excel and choose to save it as a .csv, you can do this through a program, although it isn't easy.
I saw some code written in native c++ once, (free) but couldn't get it to work. There are some good modules in python/ and apache have some good stuff too.
If you want .net has great functionality with excel.
rudasi -2 Light Poster
Thanks for your reply. The reason im trying to stay away from just opening and saving it as a .csv is cause I want to select certain data from the table which I want to convert to a separate .csv document. I will look into .net though.
iamthwee
.net has the drawback that you need excel installed on the machine you're running your program from.
rudasi -2 Light Poster
I actually got an idea. I am think of writing a program in vba to create a new sheet with the information i need from the main sheet and then maybe use a macro to convert the new sheet to .csv. The only problem is I dont know vba ;)
marco93 -87 Junior Poster
It's very easy in C or C++.
It's a Win32 FAQ for about 15 years.
See on Professional Win32 api Group
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.