import data from exel to tableview

[daly001]

can i import data from exel to tableview ????

[Lykurg]

Yes you can.

[daly001]

so who ???

[ChrisW67]

However you want. There is no magic QImportFromArbitraryExcelSpreadsheet class in Qt. You have to code it yourself. Your options include:

• Export the spreadsheet to CSV (or similar) and read that data in as a text file
• Save the Excel spreadsheet in an XML format and use QDomDocument or QXmlStreamReader
• Use ActiveQt to automate Excel and read the cell data of interest
• Use ODBC to treat the Excel spreadsheet like a table