Welcome to the Java Programming Forums

The professional, friendly Java community. 21,500 members and growing!

The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.


Members have full access to the forums. Advertisements are removed for registered users.

Results 1 to 3 of 3

Thread: Reading from a Text file & writing to Excel spreadsheets

  1. #1
    Junior Member
    Join Date
    May 2012
    Thanked 0 Times in 0 Posts

    Exclamation Reading from a Text file & writing to Excel spreadsheets

    Hi there,

    I'm trying to read numeric data from a text file & I want to write each number in a seperate cell in an Excel spreadsheet. Can somebody help ???

    Input data is as below:
    3008,45,14,277,10,6371,223,208,116,3036,1,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,1,0,0,0,0,0,0,0,0,0,0,0,2
    2893,114,16,108,30,5066,245,223,102,4340,1,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,1,0,0,0,0,0,0,0,0,0,0,0,2

    I want each value in a different cell.

    Please help. Its kinda urgent

    With regards

  2. #2
    Administrator copeg's Avatar
    Join Date
    Oct 2009
    Thanked 832 Times in 772 Posts
    Blog Entries

    Default Re: Reading from a Text file & writing to Excel spreadsheets

    Please read the forum rules - double posting is not allowed. Your other post has been deleted.

    I also recommend defining where you are stuck (reading a file, writing excel?) as we have no clue where the problem truly resides. And last but not least - everyone's question is urgent to them. Stating your problem is urgent can be considered rude to everyone else here seeking help, and everyone trying to help them.

  3. #3
    Forum VIP
    Join Date
    Jul 2010
    Thanked 329 Times in 305 Posts

    Default Re: Reading from a Text file & writing to Excel spreadsheets

    If you are interested in reading/writing Excel Spreadsheets, you should do some research on the different external libraries that are available. If you spent enough time reading and understanding the text-design of Excel files, you could probably figure out how to read/write to them without using an external library, but just getting a good external libraries would be a thousand times less time consuming.

    When asking for help, please follow these guidelines to receive better and more prompt help:
    1. Put your code in Java Tags. To do this, put [highlight=java] before your code and [/highlight] after your code.
    2. Give full details of errors and provide us with as much information about the situation as possible.
    3. Give us an example of what the output should look like when done correctly.

    Join the Airline Management Simulation Game to manage your own airline against other users in a virtual recreation of the United States Airline Industry. For more details, visit: http://airlinegame.orgfree.com/

Similar Threads

  1. File I/O reading from text and writing to another, PLEASE ADVISE! basic
    By Loki617 in forum File I/O & Other I/O Streams
    Replies: 14
    Last Post: April 16th, 2012, 01:29 PM
  2. Beginner I/O Help: Writing To a Text File At the End of Existing Lines of Text
    By BloomingNutria in forum File I/O & Other I/O Streams
    Replies: 1
    Last Post: February 28th, 2012, 03:03 PM
  3. file reading & writing
    By macko in forum What's Wrong With My Code?
    Replies: 7
    Last Post: May 12th, 2011, 08:54 AM
  4. Reading a writing binary file
    By stu1811 in forum File I/O & Other I/O Streams
    Replies: 1
    Last Post: July 30th, 2010, 12:58 PM
  5. Reading and Writing Text Files
    By kappasig84 in forum File I/O & Other I/O Streams
    Replies: 1
    Last Post: March 1st, 2010, 07:16 PM

Tags for this Thread