LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Reading Excel data using Java Jakarata POI HSSF

Hello,
as part of my work I was required to write Java application that reads data
from excel file - which I did - using Java Jakarata POI HSSF, and it works
just fine with the excel test files I created for it.

now I started to receive excel files from an outside mechanism - which is a
black box for me - the excel files I'm getting from it are weird: my
application connects to the file, but only manages to read empty values from
it "" (the files I'm getting is the exact same format and template as the one
I created to test my application).

I've found that If I simply save the files through the Excel application
(just click on the 'save' icon) - the file is somehow changes (it's size
increased about 20%) - and now my application can read from it.
I receive and save the file on the same format: "Microsoft Office Excel
Workbook" (2003). you can view the problematic file he
www.geocities.com/kuznitsshemer/report.xls

my questions are as followed:
1) why is this happening? is this a file format issue?
2) is there an easy fix for this problem ?
2) if not, how can I automatically reproduce the 're-save' solution? (by
java code, or maybe using outlook VBA or even a batch file ?)

thanks.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Web Query for Java Applet driven data website mingInv Excel Discussion (Misc queries) 1 August 25th 10 06:14 AM
Reading data arrays from multiple data files in excel Hankjam[_2_] Excel Discussion (Misc queries) 0 February 7th 08 08:29 PM
Use excel with java to store data JJ Excel Programming 1 September 11th 06 01:12 PM
data not viewable after installing Java JRE version 1.5.0_06 John Andrews Excel Worksheet Functions 0 February 7th 06 03:00 PM
Sharing data with Java? Don Wiss Excel Programming 2 May 2nd 05 10:03 AM


All times are GMT +1. The time now is 03:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"