Solved

File Conversion

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How do you programatically show and hide the Windows 10 On-Screen-Keyboard? 3 813
NotAlone Challenge 20 85
mapAB Challlenge 35 160
Problem to event 3 105
Introduction: Dynamic window placements and drawing on a form, simple usage of windows registry as a storage place for information. Continuing from the first article about sudoku.  There we have designed the application and put a lot of user int…
Introduction: Hints for the grid button.  Nested classes, templated collections.  Squash that darned bug! Continuing from the sixth article about sudoku.   Open the project in visual studio. First we will finish with the SUD_SETVALUE messa…
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.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

820 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