Tips and Tricks
An assorted list of small and interesting stuff to help you get the most out of FlexCel.
We will be adding new tips regularly here, so make sure to check this page from time to time.
In this section:
Sometimes you want to know the number of pages needed for a report, before actually exporting or printing it.
When autofitting rows, you might want to use ExcelFile.CellMarginFactor besides adjustment.
There is no such thing as a "Universal CSV" which everyone can understand. To create a CSV file, you need to know who will be reading it.
Don't use APIMate for this.
Excel has some numeric formats that vary from locale to locale. Let's get a more in depth look under the covers.
Some numeric formats in Excel change depending on your machine locale. FlexCel will by default pick your locale from the machine configuration too, but you can change those without modifying the machine settings.
Here we discuss the different ways to embed a barcode in your file using FlexCel.
Hyperlinks in a cell aren't as straightforward as other cell properties. Here we discuss how they work and how to get the link in some specific cell.
You open an existing file with FlexCel and save it. Now the file is some kilobytes smaller. What is happening?
Sometimes you might want to open the generated files directly in Excel without asking the user where to save them first. While this is not technically possible, in this tip we show a way to simulate it.
FlexCel supports both normal and strict xlsx files. Which one should you use?
A simple code snippet to find out the version of FlexCel that you are using from inside your application.
You are creating documents. How do you ensure that nobody alters the data on them?
Whenever you need change the format of a cell depending on its value, conditional format is here to help.
If there only was a simple way to enter "=B1" in A1 and "=B2" in A2...
We also tell you about a simple way to check if all the formulas in a range have consistent values (so the formula in A1 refers to B1, and the formula in A2 refers to B2 and so on)
Excel 2007 made changing the font name in a cell a little more complex than what it should be.
You can enter multiple lines of text inside a single cell, but there are a couple of things to be aware of.
What does a column width of 8.44 actually mean?
I have my data in this dataset. How do I export it to Excel?
If you have lots of big files to analyze, you might not want to load the full files into memory just to check if you need to process them.