Hi,
Actually APIMate does show you the code (if you try to compile it you will see it produces a file without headers), but I agree it isn't trivial to find. I'll see if maybe a comment can be added for APIMate or what can be done to make it easier to find.
The thing is, all this stuff is set in xls.SheetOptions (see http://www.tmssoftware.biz/flexcel/doc/vcl/api/FlexCel.Core/TExcelFile/SheetOptions.html and more relevant http://www.tmssoftware.biz/flexcel/doc/vcl/api/FlexCel.Core/TSheetOptions.html )
APIMAte Reports for Delphi:
//There are 2 ways to set the sheet options. You can use the code above to set them all, or the commented code after it to set them one by one.
xls.SheetOptions := TSheetOptions(176);
// xls.ShowGridLines := false;
Which I don't know why it isn't showing individual values. I'll see to fix it. In FlexCel.NET it is better:
//There are 2 ways to set the sheet options. You can use the code above to set them all, or the commented code after it to set them one by one.
xls.SheetOptions = TSheetOptions.ZeroValues | TSheetOptions.AutomaticGridLineColors | TSheetOptions.OutlineSymbols;
// xls.ShowGridLines = false;
But well, in both cases the problem is that TSheetOptions.ShowRowAndColumnHeaders must be 1 (not 0) in the most common case, so it doesn't appear in the SheetOptions reported by APIMate.
Also most of those sheetoptions have convenience methods like "xls.ShowFormulaText" which you can use instead of setting SheetOptions directly, but as you can see in http://www.tmssoftware.biz/flexcel/doc/vcl/api/FlexCel.Core/TSheetOptions.html ShowHeaders doesn't have a method.
But in short, just do
xls.SheetOptions := TSheetOptions(integer(xls.SheetOptions) and not integer(TSheetOptions.ShowRowAndColumnHeaders));
to suppress display of headers. And remember this is by sheet, so if you have more than 1 sheet, you will have to loop over each one hiding the headers in every one.