Index out of bounds error

[Peter Annandale]

Bruce,
          Hi.. I am getting an issue with the import again similar to the one i got back in my post from the 08/08/2016 (Object reference not set). The error occurs when trying to open an xlsx file that has been generated from SSRS reporting services.

If I open the file in excel then save and then import the file all is good.

Regards.
Peter

[shriop]

Can you email me a small repro file if you haven't already?

And what DataStreams version are you currently using?

Bruce Dunwiddie

[Peter Annandale]

Bruce,

       Have attached the file that was giving me the error.

Regards..

Peter

Regards
Peter.

--
You received this message because you are subscribed to a topic in the Google Groups "CSVChat" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/csvchat/Kyt4SJtoy_U/unsubscribe.
To unsubscribe from this group and all its topics, send an email to csvchat+unsubscribe@googlegroups.com.
To post to this group, send email to csv...@googlegroups.com.
Visit this group at https://groups.google.com/group/csvchat.
For more options, visit https://groups.google.com/d/optout.

[Peter Annandale]

Bruce,
          Have you had a chance to look at this?
Regards..
Peter

[shriop]

Yes, it's a nasty one. Something very specific to this situation is somehow throwing off the xml parser and I'm having a rough time narrowing down the issue. I can't just work around it since it's hinting at something larger being wrong with the xml parsing. It'll be a few more days and hopefully I can get somewhere with it.

Bruce Dunwiddie

[Peter Annandale]

Bruce,
          Ok thanks, the weird thing is if you open it in excel then save the issue goes away.

Regards
Peter

Regards
Peter.

To unsubscribe from this group and all its topics, send an email to csvchat+u...@googlegroups.com.

[shriop]

Ya, that's not as odd as you would think. That's kind of been the problem with this parser. The Office Open XML "standards" can be interpreted in multiple ways, even inside Microsoft, so they're generating the XML differently between all the different tools, but my code started based on how Excel generates it, and I've been trying to expand over the years to handle more and more variations.

I think the situation here is that SSRS is using a streaming format whereas Excel writes it out from memory, and the streaming format takes shortcuts.

Bruce Dunwiddie

[shriop]

Ok, I've corralled the issue and released a new version v5.26. I've emailed you a new download link.

Bruce Dunwiddie

[Peter Annandale]

Bruce,
           Thanks for that, this is still the best product out there.

Regards
Peter