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