How to create formatted ex.sheet in java

Account Information

Reset password

An email has been sent to you with instructions on how to reset your password.

Back to TechRepublic

Welcome to TechRepublic!

By registering, you agree to the Terms of Use and acknowledge the data practices outlined in the Privacy Policy.

You will also receive a complimentary subscription to TechRepublic's News and Special Offers newsletter and the Top Story of the Day newsletter. You may unsubscribe from these newsletters at any time.

Username must be unique. Password must be a minimum of 6 characters and have any 3 of the 4 items: a number (0 through 9), a special character (such as !, $, #, %), an uppercase character (A through Z) or a lowercase (a through z) character (no spaces).

General discussion

Creator

Topic
December 3, 2001 at 7:53 pm #2131856

How to create formatted ex.sheet in java

Locked

by rits_cyber · about 20 years, 5 months ago

My project needs one report which should be able to open in excel . It needs to be well formated , like first two columns fixed , left 3 col. fixed . Need to show colors in different cells (according to data) .
And I need to give a link to user to download this file. My problem is that how do I format data in csv format , so that when user open file in excel it would open in formatted form. ?

This conversation is currently closed to new comments.
Creator

Topic

All Comments

Author

Replies
- December 4, 2001 at 12:17 am #3547137
  
  How to create formatted ex.sheet in java
  
  by jay eckles · about 20 years, 5 months ago
  
  In reply to How to create formatted ex.sheet in java
  
  CSV (comma separated values) is just a data file format that provides for the separation of field values in records. It doesn’t provide for any formatting of the data. Excel can open a CSV file, but from within the CSV, you can’t specify colors, column widths, etc. I can think of two possible routes:
  
  1. write a macro in Excel that automatically formats the sheet based on the data in the CSV file
  
  2. Find a class that will write true Excel documents. A search on Google will probably getyou far in this area.
  
  Good luck.
  
  Jay
  http://www.jayeckles.com
  - May 22, 2002 at 3:54 pm #3660074
    
    How to create formatted ex.sheet in java
    
    by rits_cyber · about 20 years ago
    
    In reply to How to create formatted ex.sheet in java
    
    The question was auto-closed by TechRepublic
- January 3, 2002 at 8:06 am #3439831
  
  How to create formatted ex.sheet in java
  
  by billp · about 20 years, 4 months ago
  
  In reply to How to create formatted ex.sheet in java
  
  You can create formated spreadsheet and then populate it using the excel ODBC driver in combination with sun jdbc-odbc bridge. You can get more information on this by going to the javaworld article on this at http://www.javaworld.com/javaworld/javaqa/2001-08/02-qa-0824-excel2.html
  
  You may also want to lock at http://www.actuate.com/Products/Software/eSpreadsheetSolutions.asp?bhcp=1
  - May 22, 2002 at 3:54 pm #3660075
    
    How to create formatted ex.sheet in java
    
    by rits_cyber · about 20 years ago
    
    In reply to How to create formatted ex.sheet in java
    
    The question was auto-closed by TechRepublic
- May 22, 2002 at 3:54 pm #3660073
  
  How to create formatted ex.sheet in java
  
  by rits_cyber · about 20 years ago
  
  In reply to How to create formatted ex.sheet in java
  
  This question was auto closed due to inactivity
Author

Replies

Viewing 2 reply threads

Start or Search

Start New Discussion

Recruiting an Operations Research Analyst with the right combination of technical expertise and experience will require a comprehensive screening process. This Hiring Kit provides an adjustable framework your business can use to find, recruit and ultimately hire the right person for the job.This hiring kit from TechRepublic Premium includes a job description, sample interview questions ...

The digital transformation required by implementing the industrial Internet of Things (IIoT) is a radical change from business as usual. This quick glossary of 30 terms and concepts relating to IIoT will help you get a handle on what IIoT is and what it can do for your business.. From the glossary’s introduction: While the ...

Procuring software packages for an organization is a complicated process that involves more than just technological knowledge. There are financial and support aspects to consider, proof of concepts to evaluate and vendor negotiations to handle. Navigating through the details of an RFP alone can be challenging, so use TechRepublic Premium’s Software Procurement Policy to establish ...

Web Development

General discussion