Error reading Excel files - issue probably due to merged cells in first row

Hello eveverybody,

I am simply trying to import data from Excel files.

Unfortunately, I am facing an issue using the read Excel function as shown in the next picture :

Image: https://us.v-cdn.net/6030995/uploads/editor/f7/okr8rkft0pl1.png

I notice that this is most probably due to the fact that cell 1A is merge with cell B1.

Indeed, when I try my process using "Unmerged.xlsx" file, it works while when I try my process using "Merge.xlsx" file, it fails.

Could you please help me to solve this issue ?

The example of the process and example files are available in attachment.

Best regards

Hervé

Find more posts tagged with

AI Studio

Errors

Excel

ETL + Data Prep

Accepted answers

All comments

Telcontar120

Either you can skip that row entirely (and just add your attribute names after manually if needed), or you can unmerge the cells prior to reading it in.

hervedelhalle

Dear Telcontar120,

Thank you for your reply. I have tried to skip this row using imported cell range parameter (value of A2:B4 for example) but I still got the error message. Is there another way to skip lines in Excel files ?

Is there a way to unmerge cells in RapidMiner process ?

Best regards

Hervé

hervedelhalle

Hello everybody,

I have managed to solve my problem using the Python Scripting extensions.

Unfortunate that RapidMiner module is not able to deal with merged cells in first row.

Best regards.

Hervé

Telcontar120

There is no way to have RapidMiner remove the merged cell formatting, but you can set the parameter in Read Excel by unchecking the "first row as names" option (see screenshot) and then go into the "Edit List" under annotations just below that and specify whatever rows you want to skip as comments.

Image: https://us.v-cdn.net/6030995/uploads/editor/r0/448uddfyts55.jpg

hervedelhalle

Dear Telcontar120,

Thank you for your reply. Could you please let me known how to use annotations parameter to skip rows ?

Best regards

Hervé