insert empty rows when plenty data with custom style
when I use ws.append() method insert rows, and use custom sytle(PatternFill(patternType='solid', fgColor="FF0000", Font(bold=True, color="000000"))
to indicate some special rows, worksheet will insert some empty lines
Example:
When I mark rows with RED back ground data are invalid, will insert empty rows.
Edited by CharlieC