empty row but has shading or colors

[chabgood]

Is there a way to see if a column has no value but has colors or shading, while importing it?

[xuri]

Yep, please reference the documentation:

• Open the workbook with OpenFile function
• Get column style index with GetColStyle function
• Get the style definition by style index with GetStyle function, you can know if the style has colors or shading in the style definition
• Get cells value in a row by GetRows function, check if the cell value is empty