Reading from xls or xlsx - with style

[Richmond Mathewson]

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: 
http://www.softinterface.com/Convert-XLS/Features/Convert-XLS-To-HTML-XML.htm

Thinking . . .

Richmond.

On 16/1/2018 10:32 pm, zryip theSlug via use-livecode wrote:
> 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 consist to
> explore the style of each chars in a cell, then return the result in
> html to have it directly usable in LiveCode. I'm not sure of the
> performances of this approach, though. It will depend on how many
> cells the sheet have and how many text each cells are containing.
>
> On Tue, Jan 16, 2018 at 8:23 PM, Matthias Rebbe via use-livecode
> <use-livecode at lists.runrev.com> wrote:
>> 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 310000
>> ‌https://matthiasrebbe.eu <https://matthiasrebbe.eu/>‌
>>
>>> Am 16.01.2018 um 19:10 schrieb Ben Rubinstein via use-livecode <use-livecode at lists.runrev.com <mailto:use-livecode at lists.runrev.com>>:
>>>
>>> I'm aware that there are a couple of libraries floating around for reading Excel documents - do any of them allow the formatting of runs of text within cells to be read? I want to import some data where some of the text in a cell may contain some parts which are in italics or bold. Are there existing libraries that support this use?
>>>
>>> Many thanks,
>>>
>>> Ben
>>>
>>> _______________________________________________
>>> use-livecode mailing list
>>> use-livecode at lists.runrev.com <mailto:use-livecode at lists.runrev.com>
>>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>
>