A few CSV questions I could not locate on the Forum.

Can multiple sheets from one csv file (e.g., excel spreadsheet csv file with "sheet1 is total of sheets 2,3, and 4" and also contains "sheet2", "sheet3", "sheet4) be imported into and displayed by one ARI Module (to display all three sheets Table2, Table3, and Table4)?

(2) Or does the csv file only read sheet1 from CSV and ignore sheets2, sheet3, and sheet4?

(2) Can the results of all three sheets be added up into a Total Summary Sheet (without creating a fourth sheet) or if Sheet1 adds up sheets2 to 4?

(3) Or do all sheets have to be summaried into either one single CSV file with only a Sheet1 (and no sheets 2, 3, and 4) or does it ignore sheets 2, 3, and 4??

(4) If there are four sheets in a CSV file, how does ARI Module read the sheets if there are four sheets in one CSV file?

In may case, I need to show sheet1 for all users; sheet1 and sheet2 for other users; sheet 1, 2, and 3 for other users, and sheets 1, 2, 3, and 4 for other users.

thanks

Hello,

CSV format doesn't support ability to use different sheets in it. It is a simple format which contains only one sheet. The extension doesn't support ability to combine data from several CSV files and show them in one table. Different CSV files can be shown in different tables.

Regards,
ARI Soft