Message-ID: <18929389.8961.1711669444073.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8960_948589131.1711669444073" ------=_Part_8960_948589131.1711669444073 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Memory Related Performance Issues

Memory Related Performance Issues

=20 Icon=20
=20

Remember to update to the newest version of OfficeWriter! New updates ar= e periodically released which include new features, tweaks to improve usabi= lity, and bug fixes to help make your OfficeWriter experience as productive= as possible.

=20
=20
=20
=20 =20 =20 =20 =20 =20 =20

Table of Contents

=20

Avoid Opening Workbooks Populate= d with Large Quantities of Data with ExcelApplication

=20

What might cause this to happen:

=20 =20

Why this method causes issues:

=20 =20

Solutions:

=20 =20

Issues with = Empty Cells

=20

1.) Referencing cells that don't exist in the input file=20

What might cause this to happen:

=20 =20

Why this method causes issues:

=20 =20

Solutions:

=20 =20

2.) E= mpty cells in the input file

=20

What might cause this to happen:

=20 =20

Why this method causes issues:

=20 =20

Solutions:

=20 =20

Apply Styles to Row/Columns, Not Cells/Areas

=20

What might cause this to happen:

=20 =20

Why this method causes issues:

=20 =20

Solutions:

=20 =20

When Possible, Use DataReaders Instead of DataTables

=20

What might cause this to happen:

=20 =20

Why this method causes issues:

=20 =20

Solutions:

=20 =20

Time= Related Performance Issues

=20

View the inform= ation on performance issues that effect the time a report takes to process<= /a>.  Even if memory performance issues were your main concern, you ma= y wish to view these fixes as well, as there tends to be some overlap betwe= en the categories.

------=_Part_8960_948589131.1711669444073--