How to read table data from excel?

Table-valued functions in finaquant .net libraries

How to read table data from excel?

Postby windy » 19 Sep 2013, 19:44

Hi, how can I read tables from an excel sheet? I installed finaquant protos.

Thanks windy
windy
 
Posts: 3
Joined: 19 Sep 2013, 19:41

Re: How to read table data from excel?

Postby finaquant » 20 Sep 2013, 19:50

You may find examples at:
Importing and Exporting a DataTable from/to an Excel file

You can also use the table function
Code: [Select all] [Expand/Collapse] [Download] (Untitled.txt)
  1. MatrixTable.Import_from_CSVfile()
GeSHi ©

.. to import a data table from an excel sheet, which needs to be exported first to a semicolon-delimited CSV file.
User avatar
finaquant
 
Posts: 61
Joined: 16 Sep 2013, 18:37

Re: How to read table data from excel?

Postby windy » 24 Sep 2013, 19:53

thanks
windy
 
Posts: 3
Joined: 19 Sep 2013, 19:41


Return to Table Functions

Who is online

Users browsing this forum: No registered users and 1 guest

cron