Skip to Content
0
Former Member
Jun 30, 2015 at 03:09 AM

Excel File with .CSV extension in ZIP

452 Views

Hi Experts,

In one of my requirements,

Scenario: FILE to IDOC/RFC/PROXY

Option1:

I am getting a ZIP file with files of type "Microsoft Excel Comma Separated" with file names as "TEST1.CSV","TEST2.CSV" in it.

Option2:

A non ZIPEED Excel File (.XLS) )with multiple Tabs like "TEST1","TEST2"

Now I need to choose which type of file I can go with to read it for PI Mappings

I am confused with Excel with CSV extension,

1) For this our File Adapter normal FCC parameters are enough or need to go for custom modules?

2) If I need to read Excel with extension .XSL which has multiple tabs, apart from custom module do we have any simple approach?

Which option is easy for PI handling..?

Appreciate your inputs on this

Regards

Siri