TXLSFILE DOWNLOAD FREE

RecalcAndVerify Use this method to validate a file. This method returns a list of blocks of column information, grouped by columns that have the same properties. Determines whether the summary columns should be right to or left to the details on outline. Reads a Cell Value and Format, using a column index for faster access. RenderObject This method renders any object chart, image, autoshape, etc into an image, and returns it.

Uploader:	JoJokora
Date Added:	24 June 2016
File Size:	59.70 Mb
Operating Systems:	Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads:	42168
Price:	Free* [*Free Regsitration Required]

AddCheckbox Adds a checkbox to the active sheet.

Even if you just open and close the file. This method renders any object chart, image, autoshape, etc into an image, and returns it. Number of columns actually used on the active sheet, including formatted columns. A2" when you are positioned at cell A1.

It can be a combobox, a listbox, a spinbox or a scrollbar. SetCommentPropertiesRow Sets the comment properties at the specified index. If there is not a comment on cell row,colthis will create an empty one. To get the real color, use TExcelFile. Note that the table might not be in the active sheet.

If you want to set up a printer specific paper size, see TExcelFile. Note that this method will only return Cell formats.

SetTable Changes an existing table. Returns the dimensions for the selected paper. Tslsfile the value of level for txlsdile row as set in TExcelFile. Removes all the tables in the active sheet. But in some cases, you might want to allow any function to be entered, no matter if is known or not: GetSheetSelected Returns true if a sheet is selected, false otherwise. Txlsflle a Cell Value and Format, using a column index for faster access.

Adds a new format to the Excel format list. HasKeepRowsTogether Returns true if there is any row marked as keeptogether in the sheet. AutofitCol col1, col2, false, 1.

If there is no manual page break on col, this method will do nothing. Sets the position in a scrollbar object.

TXlsFile Class | FlexCel Studio for VCL and FireMonkey documentation

Gets the popup placement for an existing comment. Use this method to know the value tlsfile a formula that applies to a cell when the formula is relative.

Returns the format definition for a given format index. When we open a stream, it is set to "". The "Bottom" coordinate of the returned range has no meaning, only Top, left and right are used. Returns a modified format with the applied conditional hxlsfile if there was any change, null otherwise. HasMacros Returns true if the file has any macros. If you want to control these options, see TExcelFile.

TXLSFile v4.1 for D3-XE10.2 Tokyo Full Source

IsNotFormattedCol True if the specified column does not have any format applied on it. Note also that this will only delete the table itself, but not the data inside. So if you want to find out which sheets are selected in a file, you should call this method after opening the file but before changing the active sheet.