Re: Reading from xls or xlsx - with style

Thanks all for the suggestions. In fact I found that although the docs for xlsx (aka OpenXML aka ECMA-376 aka ISO/IEC 29500) are a dense nightmare*, simply taking a close look at the format shows it's pretty simple to parse by reading the files directly, at least for my needs (just text and

Re: Reading from xls or xlsx - with style

Ben wrote: > I want to import some data where some of the text in a > cell may contain some parts which are in italics or bold. SpreadLib doesn't have styles for IMPORT yet, but SpreadOut already has them for EXPORT. Text size, bold/italic/etc, pics. At least my dev version does! I need to

Re: Reading from xls or xlsx - with style

Matthias, if by tooltip, you meant the comment associated to a cell, yes this is something potentially possible, too. On Tue, Jan 16, 2018 at 9:52 PM, Matthias Rebbe via use-livecode wrote: > As i wrote “ at least i am not aware of it” ;) > > good to know. That

Re: Reading from xls or xlsx - with style

If you export html from Open Office Calc / Excel, then import it into a textfield, and then move it into a Basic Table Field like this: set the columnDelimiter to TAB set the htmlText of fld "fSPREAD" to the text of fld "fTEXT" where field "fSPREAD" is a table field all the styling from your

Re: Reading from xls or xlsx - with style

If you could find a way to export a tab-delimited RTF file from your spreadsheet program you might be laughing. Richmond. On 16/1/2018 10:54 pm, Richmond Mathewson wrote: Open Office can read Excel files and successfully export them to .html preserving ALL formatting! As Open Office is open

Re: Reading from xls or xlsx - with style

Open Office can read Excel files and successfully export them to .html preserving ALL formatting! As Open Office is open source code . . . . https://www.openoffice.org/ I have just imported a styled .html file exported from an Open Office Spreadsheet into a textField in LiveCode 7.1.4

Re: Reading from xls or xlsx - with style

As i wrote “ at least i am not aware of it” ;) good to know. That this is possible. Btw.: Do you know if it is also possible to read/get the tooltip of a cell of better said of a range of cells? Regards Matthias Matthias Rebbe Tel +49 5741 31 ‌https://matthiasrebbe.eu

Re: Reading from xls or xlsx - with style

It is amazing how many online xls to html converters are available . . . if only one could get at their code . . . This loooks a bit "dicky" as it is either to a barebones html file and a load of connected files or to something called an .mht or .mhtml file. Here's something else:

Re: Reading from xls or xlsx - with style

In the Excel Lib, the command XCEL_Range_FontStyle_Get is returning the style of the whole cell or range. We have no function to read the style of each char, at this moment. However, both VBA and AppleScript are offering this possibility, so this is a function we can add. A possible solution would

Re: Reading from xls or xlsx - with style

Ben, i am uising Spreadlib and Excel Libary. Both do not take care for text format. At least i am not aware of it. Regards, Matthias Matthias Rebbe Tel +49 5741 31 ‌https://matthiasrebbe.eu ‌ > Am 16.01.2018 um 19:10 schrieb Ben Rubinstein via use-livecode >