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?
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?
In excel just go to save as > and choose the .csv option. It would be easier.
i need to do it programmatically
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.