Solved

File Conversion

Posted on 2000-03-02
2
152 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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Strange date stored 22 100
Folder Comparison 12 52
Host to IP 7 73
while loop over for loop 7 79
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…
Introduction: Dialogs (1) modal - maintaining the database. Continuing from the ninth article about sudoku.   You might have heard of modal and modeless dialogs.  Here with this Sudoku application will we use one of each type: a modal dialog …
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.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

708 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now