.
...
- Looping through and referencing a large amount of cells, some of which are empty, while looking for something.
- A search might go past the end of a column or row if the extent of the data is not known.
- Creating large areas which extend past where the data is located.
| Code Block |
|---|
/\* INCORRECT EXAMPLE:
Area testArea = ws.CreateArea(1,1,75,75);
// If the entire area is not populated with data, then this results in empty cells being created, as they are a part of the area.
\*/
|
Why this method causes issues:
...
- Don't vaguely guess how much area a data set might take, try to narrow down the area as much as possible towards only populated data.
- Start with the range of populated cells so you are only looping through theirs.
Code Block // CORRECT CODE: Area testArea = ws.CreateArea(1,1,20,4); // Create areas that are as accurately sized to the data as possible, as opposed to vastly overscaled.
2.) Empty cells in the input file
...