Extracting data from SYLK files

[Anonymous]

Hello,

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

Best regards.

[Anonymous]

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

[Anonymous]

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)

talend_slk_bug.PNG

[Anonymous]

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

[Anonymous]

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.

[Reda_Sdn]

HI @charaf RAGBA​ ;

Did you find a solution to read the SLK file;

I have the same issue;

Thank you,

[Anonymous]

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