File Conversion

I am working on Data processing project.
I want to read data of Excel file & stored into any text file .
I gone worked on excel file format & the file structure it has designed.
But, the format is quite difficult to get? Pls, if anyone know about fileformat conversion ple. let me know .
Thank you
vgopaljiAsked:
Who is Participating?
 
ElmerFudConnect With a Mentor Commented:
File formats are a highly guarded Microsoft secret.  I'm sure if you ever got it, it would be very tough to deal with.

I suggest you save your excel worksheets as text files.  Click file, save as, down in the file type, choose CSV file and click save.  This will place commas betwwen each field and a return after each row.

You can even automate this with the macros.

--ElmerFud
0
 
vgopaljiAuthor Commented:
Hello ElmerFud
  Thanks for your immediate reply.
But, problem is that, by knowing excel file name we have to read the data int some text file or buffer without save as CSV file type.
Any how thank you. Pls, reply if you find some solution..

with rgrds
vgopalji
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.