954,525 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

export excel sheet as a csv

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?

poojapo
Newbie Poster
3 posts since Apr 2007
Reputation Points: 10
Solved Threads: 0
 

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

iamthwee
Posting Expert
5,950 posts since Aug 2005
Reputation Points: 1,543
Solved Threads: 439
 

i need to do it programmatically

poojapo
Newbie Poster
3 posts since Apr 2007
Reputation Points: 10
Solved Threads: 0
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You