topic Re: Extracting data from SYLK files in Talend Studio

Extracting data from SYLK files

Anonymous — Thu, 08 Nov 2018 15:18:54 GMT

Hello,

Is there a way to extract data from an .slk file in Talend ver 6.4?

Best regards.

Re: Extracting data from SYLK files

Anonymous — Fri, 09 Nov 2018 06:40:15 GMT

Hi,

There are no specific components to open .slk file. As per file info site, you can open it by Excel.

https://fileinfo.com/extension/slk

So could you please try to open it by tfileinputExcel or tfleinputdelimited and let us know whether it helped you? If you are facing any issue during file reading, could you please share the job and component screenshots with a sample file for further analysis?

Warm Regards,

Nikhil Thampi

Re: Extracting data from SYLK files

Anonymous — Fri, 09 Nov 2018 08:23:21 GMT

Hi nikhilthampi,

I tried both component you've mentioned, they can't read this format.

Especially tFileInputExcel.

I create the schema in Build-in mode to match the file structure, after running I got that error message:

Spoiler

Exception in component tFileInputExcel_1 (Test)
jxl.read.biff.BiffException: Unable to recognize OLE stream
at jxl.read.biff.CompoundFile.<init>(CompoundFile.java:116)
at jxl.read.biff.File.<init>(File.java:127)
at jxl.Workbook.getWorkbook(Workbook.java:268)
at local_project.test_0_1.Test.tFileInputExcel_1Process(Test.java:715)
at local_project.test_0_1.Test.runJobInTOS(Test.java:1482)
at local_project.test_0_1.Test.main(Test.java:1331)

Exception in component tFileInputExcel_1 (Test)jxl.read.biff.BiffException: Unable to recognize OLE streamat jxl.read.biff.CompoundFile.<init>(CompoundFile.java:116)at jxl.read.biff.File.<init>(File.java:127)at jxl.Workbook.getWorkbook(Workbook.java:268)at local_project.test_0_1.Test.tFileInputExcel_1Process(Test.java:715)at local_project.test_0_1.Test.runJobInTOS(Test.java:1482)at local_project.test_0_1.Test.main(Test.java:1331)

talend_slk_bug.PNG

Re: Extracting data from SYLK files

Anonymous — Fri, 09 Nov 2018 08:39:35 GMT

Hi,

In this case, you will not be able to read the file directly using Talend component directly.

But if you create a Talend routine to read the file to a better readable format, existing Talend components can take it from there.

Warm Regards,

Nikhil Thampi

Re: Extracting data from SYLK files

Anonymous — Fri, 09 Nov 2018 09:49:56 GMT

Thank you for your reply ,

Ill try to create a routine to convert that file.

By any chance if you have the method to do the conversion, could you please post it for me?

Best regards,

Charaf.

Re: Extracting data from SYLK files

Reda_Sdn — Mon, 20 Jun 2022 12:11:58 GMT

HI @charaf RAGBA ;

Did you find a solution to read the SLK file;

I have the same issue;

Thank you,

Re: Extracting data from SYLK files

Anonymous — Tue, 21 Jun 2022 03:50:28 GMT

Hello,

So far, there is no a specific component to open .sylk file in talend.

Feel free to create a new feature jira issue on talend bug track.

Best regards

Sabrina