Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Downloads

You can download the code for the best performance samples as a Visual Studio solution.

  • (Link to code goes here.)

Avoid Opening Workbooks Populated with Large Quantities of Data with ExcelApplication

...

  • Apply styles to large numbers of cells by setting the style to either rows/columns or to singular data marker cells.
  • If more than one style is needed in a row/column, and it can't be handled by switching the style for the other (ie, setting style on a row to change part of a column), try to keep the style that takes a majority of the row/column as the one set by that row/column.

Downloads

You can download the code for the best performance samples as a Visual Studio solution.

  • (Link to code goes here.)