I want to read the data from a worksheet in an excel workbook, write it to a new worksheet and save that as a dbf or csv file (one worksheet)...basically extracting worksheets from a workbook and saving them individually, renaming them as the title of the worksheet with the title of the workbook (either one first).

What I have tried to do (I don't have the code on me right now)
is read each column in the worksheet and write it to a new file, but I get all of the 5 columns from the original file written to the A column of the new file. How can I start each column at the top of the appropriate column, or is there a better way to do it?

I can post the code later if need be...Thanks.

Recommended Answers

All 2 Replies

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.