LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: cpeckham

Hi!
Quick question: I have a directory node pulling in 90+ workbooks.
How does Lavastorm Import Excel Node handle Merged cells?
If B1:E1 is merged and the values are {A1,B1:E1,F1} = {a,b,c} will the import show {a,b,c} or {a,b,{empty},{empty},{empty},c}?
If possible, I'd like to know which cells the merge is covering (and avoid adding a VBA pre-processing macro to the lavastorm mix).
Any recommendations?
Thanks.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: cpeckham

Update: Lavastorm does {a,b,null,null,null,c}.
Is there a way to detect and export excel comments?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ltolleson

So it seems that any value in a merged cell gets read in as the first cell of the merge. Looking at the data, all remaining merged cells contain NULL values. The attached graph will remove any field in the data where every record in a single field is NULL. From the data we are assuming these are fields that were part of a merged cell.

There is no way up front to detect if Excel cells are merged. We also do not detect and read Excel comments.

Hope this helps...
Attachments:
RemoveMergedFields.zip