Reading from xls or xlsx - with style
zryip.theslug at gmail.com
Tue Jan 16 15:32:01 EST 2018
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:
> i am uising Spreadlib and Excel Libary. Both do not take care for text format.
> At least i am not aware of it.
> 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,
>> 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:
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
More information about the use-livecode