Solved

File Conversion

Posted on 2000-03-02
2
155 Views
Last Modified: 2013-11-20
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
0
Comment
Question by:vgopalji
2 Comments
 
LVL 1

Accepted Solution

by:
ElmerFud earned 100 total points
ID: 2576237
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
 

Author Comment

by:vgopalji
ID: 2576513
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

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Question regarding Copy/Paste 16 96
Expand macro to ask for filename column 8 37
if loop in java 3 142
how to use laptop or pad camera in vb.net windows application 2 73
Introduction: The undo support, implementing a stack. Continuing from the eigth article about sudoku.   We need a mechanism to keep track of the digits entered so as to implement an undo mechanism.  This should be a ‘Last In First Out’ collec…
If you use Adobe Reader X it is possible you can't open OLE PDF documents in the standard. The reason is the 'save box mode' in adobe reader X. Many people think the protected Mode of adobe reader x is only to stop the write access. But this fe…
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question