When outputting data using an Excel template, the formatting of the first line of the main data sheet is applied to the entire sheet, but the formatting is not applied to another sheet connected to the main data sheet.

Therefore, it is necessary to apply formatting to the other sheet in advance, but if the amount of data to be output with formatting applied becomes large, performance will deteriorate and a timeout error will occur, making it unusable (extremely slow movement when there are more than about 30,000 items). The formatting of the first line should be reflected to the entire data sheet, even if it is not the main data sheet.

Category: General