Accessing RTF excel document cells

Hi all,

I have a project coming up that would really benefit from me being able to access cells from a fully formatted excel spreadsheet (that could be updated relatively quickly, without to much of an export debacle).

Anyone have any advice or experience?

you have two options:

  1. save your Excel file as a CSV or TSV file, open with File in DAT

  2. install a Python module which can read Excel files, see an example here:
    viewtopic.php?f=22&t=8389&p=31586

based on this library:
openpyxl.readthedocs.io/en/stable/

Can DATs support formatted text? (even just italics and underline) also needing multi language support, which the CSV option seems to have failed on.

failed to get openpyxl running properly, but I’m guessing i’ll run into the same no formatting in textDAT problem wont I…

CSV files and DATs both are only for data, they don’t support any formatting.