hi,

I wish to know if there is a way in perl using Win32::OLE to export a specific Excel Worksheet (not the entire workbook) from a workbook as a .csv file?

Can you give me the sample code for the same?

Member Avatar for iamthwee

In excel just go to save as > and choose the .csv option. It would be easier.

i need to do it programmatically

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.