excel « Media File « Java I/O Q&A





1. Convert Excel 2003 XML file to Excel 2003 XLS format    stackoverflow.com

Is there a way to convert Excel 2003 XML file to Excel 2003 XLS format with Java? Or at least any open source framework that can do this? Thanks, Matthew Huang

2. Protect excel file with java    stackoverflow.com

Is there a way to create open protected excel file in Java? I'm looking at JExcelApi and Apache Poi projects but with both of them I cannot figure out how to ...

3. Java Excel API: Add images to the footer of excel files    stackoverflow.com

I've got a bunch of huge excel reports created by JExcel. Now the company's styleguide has changed and somebody had the great idea to add some logos to the footer. Unfortunately, ...

4. Apache HSSF POI excel doc to tab delimted file    stackoverflow.com

went and got a file that already "works" from here: xls to csv Note, I wanted a tab delimited format, so I just went in and changed "," to "\t" ...

5. Reading Excel file (.xls) in Java    stackoverflow.com

I want to read text from excel file in J2SE using NetBeans. I found an article here about using Apache POI and JExcelApi, but I'd prefer not depending on external packages. ...

6. Convert from Excel xlsx to xls in Java    stackoverflow.com

I have an Excel 2007 xlsx file that I would like to programmatically convert to an .xls file. The xlsx file is an export from a reporting tool, and I would ...

7. File size issue. while poi read write    stackoverflow.com

I am using apache poi api to deal with my spread sheet files. I have observed, if we try to edit an existing .xls file it size is not the same as ...

8. Octave Error with XLS functions    stackoverflow.com

I just started using Octave, and have been trying to do some operations from data in Excel files. I've installed the IO, Java, and Windows packages in Octave, but when ...

9. Converting JSON to XLS/CSV in Java    stackoverflow.com

Does anyone have any sample Java code to convert a JSON document to XLS/CSV file? I have tried to search on Google but to no avail.





10. Java API which will compress the xls file in xls format    stackoverflow.com

I am having an excel file but the file size is to large, do you have any suggestion so that we can reduce the file size in the same format?

11. Insert image to excel file using JXL without stretching it    stackoverflow.com

I can insert image to my excel file using jxl usingsheet.addImage(WritableImage obj). My problem is that, it stretches based on the args of WritableImage. I'm wondering if there is a way ...

12. how to read from a .xls(ms excel) file    coderanch.com

How can i read data from a ms excel file.Suppose i have a .xls file which contains a data of all the employees and their salary details.Now i need to read specefic salary details of an employeefrom that file and for that i need to scan through the whole document to get the required information.

13. how to read from a .xls(ms excel) file    coderanch.com

How can i read data from a ms excel file.Suppose i have a .xls file which contains a data of all the employees and their salary details.Now i need to read specefic salary details of an employeefrom that file and for that i need to scan through the whole document to get the required information.

14. saving excel file into an image    coderanch.com

Hi, The problem is I want a solution to convert excel file into an image, i.e., an application which should read an excel file (some range of cells) and save it as an image (jpeg, bmp). I am trying by using POI but it is not capturing the data in the image. Regards vishnu

16. using java api how i can append image in excel file    coderanch.com

hi, using jxl api i can able to write data in the excel file also i can append the image using WriteableImage class. But my problem is my project is already implemented in POI api. so i need a java code only to append image in that . so if any body have anyidea please tell me. but that should be ...





17. reading Excel(.xls)file    coderanch.com

18. How can we read protected password excel file (.xls) with POI API    coderanch.com

I've just learned POI and find the HSSF is very simple to read and create excel file (.xls). However, I found some problem when want to read excel protected with password. It took me an hour to find this solution on internet. Please could you help me to solve this problem. I'm very glad if you could give me a code ...

19. Extract images from Excel files    coderanch.com

Hello ranchers, how are you doing? I'm not sure if I should post this issue in the Servlets forum, but I did so because in the end, I'll be solving the issue in a servlet... (duh ) Ok, so my problem is this: I have several Excel files with 7 worksheets each. Inside there are 10 images per sheet. Does any ...

20. Reading an XLS (Excel) file. Row by row.    coderanch.com

Howdy everyone, I need to make a program that will read XLS files in this form: (rows seperated by a ';') (first row) Id student name;LockerNo;Combination;Teacher (second row) record1 (third row) record2 and so on... I need to be able to read a certain file to compare with an other (specifically to check for records that are in the first but ...

22. Writing in existing excel(.xls) file    coderanch.com

Hi All, I want to write in an existing excel(in sheet1) file in a perticular cell(say row=1,cell=6). I'm using poi jar. But I could not write in that perticular cell. String val= //value that I want to write; String filePath = //getting the filepath. ; File file=new File(filePath); FileInputStream fis=new FileInputStream(file); HSSFWorkbook wb=new HSSFWorkbook(fis); HSSFSheet st=wb.getSheet("Sheet1"); HSSFRow row=st.getRow(1); HSSFCell cell= row.getCell(6); ...

23. Writing in existing excel(.xls) file    coderanch.com

Hi All, I want to write in an existing excel(in sheet1) file in a perticular cell(say row=1,cell=6). I'm using poi jar. But I could not write in that perticular cell. String val= //value that I want to write; String filePath = //getting the filepath. ; File file=new File(filePath); FileInputStream fis=new FileInputStream(file); HSSFWorkbook wb=new HSSFWorkbook(fis); HSSFSheet st=wb.getSheet("Sheet1"); HSSFRow row=st.getRow(1); HSSFCell cell= row.getCell(6); ...

25. parsing .xls(excel) file and creating a .xdat(xml) file out of it    forums.oracle.com

Hi All, need some tips on a task i am trying accomplish for some days now. I have a excel file, in which I have 10 columns with 40-50 rows of data. I have a xml structure in mind, in which I want to put all these data from excel file. But till now I haven't understood exactly how I should ...

27. set different font for each cell in excel file created using JXL(core java)    forums.oracle.com

Hi friends, I want to set different font for each cell in one excel file created using jxl concept of core java technologies. ie. I am looking for multiple cellfont concept. example: In one excel file 1st cell-Arial 2nd cell-Times New Roman I am posting this everyday and no one is helping me out and i want the source code or ...

28. Converting Word Files n Excel Files To TIFF images using java    forums.oracle.com

MS keeps their formats secure, it's how they make money. There was a project from Apache (sub-group anyway), that was doing some work on it, but documentation and results were very flaky. However, TIFF has a format that people can use. Search the web for the format, get the details on the byte structure, then simply apply. Now, to convert between ...