issue importing excel data into Calc 7

classic Classic list List threaded Threaded
1 message Options
Dave Stevens Dave Stevens
Reply | Threaded
Open this post in threaded view
|

issue importing excel data into Calc 7

In order to obtain data to serve as a basis for Calc 7.0.0.3 charts I
need to import excel formatted sheets from an oracle query program. I
have very limited control over the data source and am pretty much
obliged to take it as it comes. Below is a snippet of what gets
imported.


Report Type : StationReport  <table cellspacing="0".the and rules="all"
border="1" style="border-collapse:collapse

There's a lot more like this. The import fails due to excessive
characters per cell

This is not useful. While casting about for some solution I tried to use
gnumeric 1.12.46 and the import proceeds as I would like (no messages
or errors) and I get useful cells of data. I can in principle (and in
practise) export the sheet from gnumeric to file x.xls then import
x.xls into Calc 7 and then use calc's chart facilities, which is the
object. The number of imports for many sheets makes this
laborious.

I would much prefer to not have the intermediate step. Is anyone able to
suggest some setting that would allow a direct import of the excel
sheet?

Thanks,

Dave

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy