How to send the Excel files into receiver system

[Former Member]

Hi,

My scenario is simple File - to - File . But from the source system I'm getting files in Excel format. and target side we have to give those files into XML format .but, how can we process these Excel files through XI . is there any option for converting Ecel files into XML files . and is possible to process the files through File conent conversion(FCC) parameters .

Please suggest me .

Regards

Jain

[aashish_sinha]

Hi ,

Blogs provided by Raj is too good.

You can also use some alternative like, you can convert excel file into csv using excel and then put this csv to XI server and treat scenarion as simple File - XI - File scenario with sender as File sender with all FCC settings.

Other thing, If you don't want to do any mapping or you want to send data exactly without any massaging, you can send that excel directly without using IR in between, else use blog provided by Raj or may be just convert your excel file as csv and after massging put it as csv in target location and just open it with excel.

Regards

Aashish Sinha

[dharamveer_gaur2]

Hi

Look this blog

[Former Member]

HI,

You have to write the Adapter module to read the data from Excel file.

Go throgh the document to read the excel file.

If you want to read the data from multiple sheeets go throgh these docs.

Regards

Goli Sridhar

[Former Member]

Hi Jain

Check this blog Read Excel instead of XML through FileAdapter by Felix Jeyareuben

Ragards

Raj