Thank you for the quick response.
I can achieve very close to what I want if I add a record listener for
blank record types. This is preferable because I need to reproduce the
data in a delimited format for insertion into a Topic, so my output now
looks like this:
SHID; Carrier; Origin City; Ori
Theoretically col and row records can appear anywhere in that section
out of order (but don't when coming from excel). You have to either
write them in some kind of better format to disk -- such as a temporary
db file -- and then read that (to avoid storing it all in memory) in a
guaranteed so
I'm trying to read in an XLS and output the contents of each row exactly
as they are read in by the file.
I have to do this with the evenusermodel because of memory limitations,
however it is proving to be very difficult.
In short, my problem is I need to keep track of how many columns there
ar
Hi all,
I am trying to detect if a file is password protected before reading it
(ie, if it is password protected, I want to ignore it). Right now, I am
just catching exceptions that get thrown, but I was wondering if there
was another way of doing this.
Thanks
Stefan,
Could you elaborate on what you're doing (and how you're doing it) when you
say "I use the hack to send a bytestream with tab separation between the
fields, store it with a *.xls extention so Excel open it with the data
correct in columns."
Thanks,
Sanjiv
On 6/20/05, Marx, Stefan ext. MA