Flat File Parser vs Excel file

[shaji_chandran]

Hi Experts,

I was using Flat File Parser to read the content of the CSV file which uploaded by the user through MII. It is working very well. Now the user would like to upload the Excel file instead of CSV. I am aware that Flat File Parser will work only with text file (such as CSV). Is there any way I can read Excel file through MII?

I am using MII 12.2 version

Thanks in advance

Shaji

[Former Member]

Hi Shahji,

You may ask the user to use the save as xml option in excel to save the files.

You may then process this as XML in BLS.

XML files thus generated have a fixed format.

Regards

Maaz

[Former Member]

Hi Shaji,

Please go through the below thread:

Also, you could create an OLEDB data server to read excel eontent,

Regards,
Anushree

[shaji_chandran]

Anushree,

Thanks for your response.

Actually my excel file is going to change every time when users upload a new files. So I am not sure this will work on that scenario.

Thanks

Shaji

[Former Member]

Hi Shaji,

Could you please state what challenges you see in using the above approach?

You could schedule your transaction to read data at regular intervals,

Regards,

Anushree

[shaji_chandran]

Hi Anushree,

Multiple users will be uploading different excel files randomly. So it will be difficult to make a connection with these excel files via Pco. Also they can give random files names while upload though they maitian same excel format.

Thanks

Shaji

[former_member185280]

Shaji,
  I usually recommend adding functionality to the excel file to send the data to MII via http post. If you do a web search for 'excel http post' you will find many examples of how to do this.
Regards,
Christian