Skip to Content (Press Enter)
UserImage.jpg
Anuarbek Onaibay
125Views
4Comments
Solved
How to read excel without header?
Question
Forge
OutSystems 11
Development
Service Studio Version
11.53.19 (Build 61407)

Hi all!

The excel file I receive is contained in a separate web app, that is being maintained by a different group of people. I already talked to them, and they wont change the excel file in any way. So here are my problems:

  • The excel file does not have header, so if I use Excel to record list the first row in excel is not being read. 
  • I tried using advanced excel, but the file is "xls" and Workbook_open throws an exception when trying to open it. 
  • I looked for ways to tranform the file from xls to xlsx, but when I try to instal "xls to xlsx" forge component, outsystems crashes. And I couldnt find any other articles about it. 

What other options do I have? Any advice would be greatly appreciated! Thank you!


1
0
06 Oct 2022
Copy Link
UserImage.jpg
Anuarbek Onaibay
Solution

So here is what we did: 

  • Downloaded the xif file of "xls to xlsx" forge component.
  • Opened it in integration studio and published it in our environment. 
  • After that it seems to be working correctly 

For some reason I didnt think of it immediately. Everything seem to work now. 

See solution in context
0
0
07 Oct 2022
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

Hi Anuar,

Great to hear you solved it! Happy coding :).

0
0
07 Oct 2022
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

Hi Anuar,

The XLSX format was introduced in 2007, 15 years ago! Using XLS is, imho, completely ridiculous, and no-one should be producing it or forced to read it.

You say "OutSystems crashes" when installing the XLS to XLSX Forge asset, what do you mean by that?

0
0
07 Oct 2022
Copy Link
UserImage.jpg
Anuarbek Onaibay

Thank you for the response! 

Not much I can do about it, its not maintained by me, I just receive it. 

I already talked to devs on the other side. They will not change the file. 

When I try to install it, I receive this message. 

0
0
07 Oct 2022
Copy Link
UserImage.jpg
Anuarbek Onaibay
Solution

So here is what we did: 

  • Downloaded the xif file of "xls to xlsx" forge component.
  • Opened it in integration studio and published it in our environment. 
  • After that it seems to be working correctly 

For some reason I didnt think of it immediately. Everything seem to work now. 

0
0
07 Oct 2022
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

Hi Anuar,

Great to hear you solved it! Happy coding :).

0
0
07 Oct 2022
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.