Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Supported by

Error reading the .xlsx file

edited July 2018 in OpenSesame

Hello,

This problem is close to the previous one (see "Refresh the source of a loop" - june 30). In this case, I am sure that the .xlsx file is the one that is present in the pool and I took all precautions that I learned from the previous case (delete and replace the Excel fil in the pool and re-select it in the loop item).
This experiment is a copy of another one that runs fine. I saved it under another name and made all the changes needed for a new version. Other parts of the program are OK, but the flow is stuck on the main loop with the following message, which is the same when I execute the program or when I just test the preview of the loop:

Preview de la table loop

Impossible de générer le preview.
Failed to read .xlsx file: c:\users\grard~1\appdata\local\temp\tmppd_eqf.opensesame_pool\Alcool - perception 2.xlsx
item-stack: 
exception type: ValueError
exception message: Not all columns have a name on the first row
time: Tue Jul 24 07:12:30 2018
Traceback:
  File "C:\Program Files (x86)\OpenSesame\lib\site-packages\libopensesame\loop.py", line 370, in _read_file
    return io.readxlsx(src)
  File "C:\Program Files (x86)\OpenSesame\lib\site-packages\datamatrix\io\_excel.py", line 64, in readxlsx
    raise ValueError(u'Not all columns have a name on the first row')
ValueError: Not all columns have a name on the first row

This message is inconsistent with the contents of the file, because the first row of each column actually contains a name. And the file is the good one. So what ?

Have a nice day and thank you in advance for your advise.
Gérard

Comments

  • Hi Gérard,

    An Excel file can have multiple sheets, and OpenSesame tries to read the one that is active, which is not necessarily the first one. Could that be the issue? If you switch to the sheet that you want to use, and then save the Excel file again, does the issue go away?

    If not, could you upload the .xlsx here so that I can take a look?

    Cheers!
    Sebastiaan

  • Hi Sebastiaan,
    There is only one sheet in the file, that I have attached.

  • Ah, I see. Columns D, E, and F don't contain any real values, but they do count as empty columns because they have formatting. And therefore OpenSesame complains that they don't have a column name. Do you see what I mean?

    Clearing the formatting of all columns except the ones with actual data should resolve the issue.

  • You are right ! And it looks like resetting the cell format to 'standard', which is the default value, is not sufficient. When the 'format' parameter has been modified once, the cell is considered 'formatted'. Hence, it is safer to copy the columns into a brand new sheet.
    Thanks a lot.

Sign In or Register to comment.

agen judi bola , sportbook, casino, togel, number game, singapore, tangkas, basket, slot, poker, dominoqq, agen bola. Semua permainan bisa dimainkan hanya dengan 1 ID. minimal deposit 50.000 ,- bonus cashback hingga 10% , diskon togel hingga 66% bisa bermain di android dan IOS kapanpun dan dimana pun. poker , bandarq , aduq, domino qq , dominobet. Semua permainan bisa dimainkan hanya dengan 1 ID. minimal deposit 10.000 ,- bonus turnover 0.5% dan bonus referral 20%. Bonus - bonus yang dihadirkan bisa terbilang cukup tinggi dan memuaskan, anda hanya perlu memasang pada situs yang memberikan bursa pasaran terbaik yaitu http://45.77.173.118/ Bola168. Situs penyedia segala jenis permainan poker online kini semakin banyak ditemukan di Internet, salah satunya TahunQQ merupakan situs Agen Judi Domino66 Dan BandarQ Terpercaya yang mampu memberikan banyak provit bagi bettornya. Permainan Yang Di Sediakan Dewi365 Juga sangat banyak Dan menarik dan Peluang untuk memenangkan Taruhan Judi online ini juga sangat mudah . Mainkan Segera Taruhan Sportbook anda bersama Agen Judi Bola Bersama Dewi365 Kemenangan Anda Berapa pun akan Terbayarkan. Tersedia 9 macam permainan seru yang bisa kamu mainkan hanya di dalam 1 ID saja. Permainan seru yang tersedia seperti Poker, Domino QQ Dan juga BandarQ Online. Semuanya tersedia lengkap hanya di ABGQQ. Situs ABGQQ sangat mudah dimenangkan, kamu juga akan mendapatkan mega bonus dan setiap pemain berhak mendapatkan cashback mingguan. ABGQQ juga telah diakui sebagai Bandar Domino Online yang menjamin sistem FAIR PLAY disetiap permainan yang bisa dimainkan dengan deposit minimal hanya Rp.25.000. DEWI365 adalah Bandar Judi Bola Terpercaya & resmi dan terpercaya di indonesia. Situs judi bola ini menyediakan fasilitas bagi anda untuk dapat bermain memainkan permainan judi bola. Didalam situs ini memiliki berbagai permainan taruhan bola terlengkap seperti Sbobet, yang membuat DEWI365 menjadi situs judi bola terbaik dan terpercaya di Indonesia. Tentunya sebagai situs yang bertugas sebagai Bandar Poker Online pastinya akan berusaha untuk menjaga semua informasi dan keamanan yang terdapat di POKERQQ13. Kotakqq adalah situs Judi Poker Online Terpercayayang menyediakan 9 jenis permainan sakong online, dominoqq, domino99, bandarq, bandar ceme, aduq, poker online, bandar poker, balak66, perang baccarat, dan capsa susun. Dengan minimal deposit withdraw 15.000 Anda sudah bisa memainkan semua permaina pkv games di situs kami. Jackpot besar,Win rate tinggi, Fair play, PKV Games