Skip to main content
Solved

Empty Excel cels break import in CPM46

  • December 23, 2020
  • 2 replies
  • 5 views

joos.buijs
Level 10
Forum|alt.badge.img+2
Hi all, Im prepping some data in Python (pandas data frames) where certain columns dont have a value for each row, e.g. are NULL or NaN for integers and floats. However, when writing the dataframe as Excel file and then loading this into Celonis CPM46 I get the error as below. When writing as CSV I do not get this error on the same data, but the files are far larger and therefore take longer to upload (working from home ) Any idea or tips how to handle this? image865226 13.2 KB

Best answer by justin.stegm

Hi @joos.buijs,

 

is this issue still valid? I would recommend to open a Servicedesk ticket if it is as this behavior is not expected.

 

Best,

 

Justin

2 replies

  • Level 0
  • Answer
  • November 24, 2021

Hi @joos.buijs,

 

is this issue still valid? I would recommend to open a Servicedesk ticket if it is as this behavior is not expected.

 

Best,

 

Justin


joos.buijs
Level 10
Forum|alt.badge.img+2
  • Author
  • Level 10
  • November 24, 2021

Hi @joos.buijs,

 

is this issue still valid? I would recommend to open a Servicedesk ticket if it is as this behavior is not expected.

 

Best,

 

Justin

Hi @justin.stegm ,

 

I don't recall so I guess I solved it or accepted it in the past year. I'll close the question for now and will open a servicedesk ticket if necessary.