|
File representing excel content
Method DetailaddWorksheet(String name, DataList list) Creates a worksheet with name at index and with content provided by list.
Parameters:
Since: 01-17-2022 String calcMD5() Returns an MD5 checksum of the contents of this file. Returns: String Since: 11-23-2012 closeReader() Resets the capability to read lines to the beginning of the file. Since: 08-13-2013 File copy() Returns a copy of the file Returns: File Since: 11-17-2011 FileBuffer createFileBuffer() Reads this compressed file and returns a FileBuffer. Throws exception if this not a supported type (zip and jar). Returns: FileBuffer Since: 08-27-2013 File decrypt(String password, String filename) Returns a new file. Assumes the content of this file is PGP encrypted.
Parameters:
Returns: File Since: 03-17-2014 deleteWorksheet(String name) Deletes the worksheet matching name.
Parameters:
Since: 01-17-2022 File encrypt(String password) Returns a new file with the content of this file PGP encrypted. The new file's filename will be existing filename+.txt
Parameters:
Returns: File Since: 05-16-2011 File encrypt(String password, String filename) Returns a new file with the content of this file PGP encrypted having the specified file name. Extensions allowed: pgp, gpg, txt, asc. Extension is required.
Parameters:
Returns: File Since: 10-07-2016 String getContentType() Returns the content type of this file Returns: String Since: 02-03-2010 String getFailureMessage() When isValid is false, contains failure message. Returns: String Since: 04-01-2009 String getFileExtension() Returns the file extension. 'Myfile.doc' returns 'doc' Returns: String Since: 06-10-2010 int getFileLength() Returns the size of the file in bytes. Returns: int Since: 08-23-2018 int getFileSize() Returns the size of the file in kilobytes. Returns: int Since: 04-10-2007 String getFileType() Returns the type of the file as specified by the upload tag or API. This may be null if the file was obtained by means other than an upload. Returns: String Since: 04-10-2007 String getFilename() Returns the name of the uploaded file (without the full path). Returns: String Since: 11-07-2007 DataReader getReader() Opens a data reader for this file. File type should be list compatible. Returns: DataReader Since: 11-20-2019 XMLReader getXMLReader(boolean removeNamespaces) Returns a ServicePayload for processing XML-based files. Returns null if the file is not XML.
Parameters:
Returns: XMLReader Since: 04-11-2023 boolean isAdHocConversionSupported() Returns true if the content supports immediate conversion to adhoc. See Packet.createAdHocDocument(File,...) Returns: boolean Since: 11-09-2009 boolean isCorrectType() Returns true if the type of the file is within the specified restriction. Returns: boolean Since: 04-10-2007 boolean isDataListSupported() Returns true if this file content can be used as a DataList. See Attachment.toDataList Returns: boolean Since: 02-03-2010 boolean isMacro() Returns true if the content of the file contains macro. Returns: boolean Since: 02-23-2010 boolean isPdfConversionSupported() Returns true if the content supports conversion to PDF. Returns: boolean Since: 03-10-2008 boolean isSizeExceeded() Returns true if the size of the file exceeds the specified restriction. Returns: boolean Since: 04-10-2007 boolean isValid() Returns true if the content of the file is valid. Returns: boolean Since: 04-10-2007 boolean isVirus() Returns true if the content of the file contains a virus. Returns: boolean Since: 04-10-2007 File pgpDecrypt(File keyFile, String password, String filename) Returns a new file with the content of this PGP encrypted file decrypted using the provided private key. The content type is guessed from the file name extension
Parameters:
Returns: File Since: 08-03-2016 File pgpEncrypt(File keyFile) Returns a new file with the content of this file PGP encrypted using the provided public key. The new file's filename will be existing filename+.txt
Parameters:
Returns: File Since: 08-03-2016 PacketDataList readDataList(String name) Creates a non persistent PacketDataList from the contents of this file. The contents must support DataList conversion (currently .csv and .xls). If xls, this will execute formulas. This method also takes liberties with regard to column names. If it encounters any blank column name it assumes the first row is data and renames all the columns as col0 - colN. If xls, it will also attempt to find a matching tab by name and if that fails, it will return the first tab. Throws exception if invalid or unsupported file format.
Parameters:
Returns: PacketDataList Since: 06-03-2020 Payload readDataLists() Creates a Payload of PacketDataList from the contents of this file. The contents must support DataList conversion (currently .csv and .xls). If xls, this will execute formulas. This method also takes liberties with regard to column names. If it encounters any blank column name it assumes the first row is data and renames all the columns as col0 - colN. Throws exception if invalid or unsupported file format. Returns: Payload Since: 05-11-2021 String readFile() Reads all of the text-based file and returns the content as a string. Returns null if there is no content. Throws exception if this file is not a text-based file. Returns: String Since: 01-20-2015 String readLine() Reads one line (of the presumably text file) and returns it, advancing the reader to the next line for subsequent reads. Returns null if this file is not text based or there are no more lines to read. Best practice-call closeReader when finished. Returns: String Since: 08-13-2013 File removeSignature() Removes the digital signature, if any. Returns: File Since: 02-26-2016 setFilename(String newFileName) Sets the name of the file to the specified name.
Parameters:
Since: 06-04-2024 File sign() Applies a digital signature to the file. Content must be well formed XML. Returns: File Since: 02-26-2016 AudioFile toAudioFile() Returns AudioFile created from this File. Method returns null if current file cannot be represented as an audio. Returns: AudioFile Since: 03-09-2018 Data toData() Returns the content of this file as a Data object with three properties: fileName, contentType, and base64. base64 will be a Base64 encoded string of the file contents. Returns: Data Since: 05-16-2011 PacketDataList toDataList(String name) Creates a non persistent PacketDataList from the contents of this file. The contents must support DataList conversion (currently .csv and .xls)
Parameters:
Returns: PacketDataList Since: 05-15-2010 ExcelFile toExcelFile() Returns ExcelFile created from this File. Method returns null if current file cannot be represented as an excel file. Returns: ExcelFile Since: 01-17-2022 ImageFile toImage() Returns ImageFile created from this File. Method returns null if current file cannot be represented as an image. The file must already be a supported image content type to use this method. If you are trying convert a PDF to an image you should just get a specified page or use toTIFF to get a multi-page TIFF file. Returns: ImageFile Since: 10-19-2011 PdfFile toPdf(String filename) Converts this file to PDF if possible. Call isPdfConversionSupported() to check if file can be converted to PDF. Returns PDF file or null if PDF conversion is not supported
Parameters:
Returns: PdfFile Since: 07-04-2011 PdfFile toPdf(String filename, String password) This method expects the document to already be a PDF. Call isPdfConversionSupported() to check if file can be converted to PDF. Returns PDF file or null if PDF conversion is not supported
Parameters:
Returns: PdfFile Since: 10-05-2017 String toString() Returns a description of this object. Returns: String Since: 01-17-2022 UnknownFile toUnknownFile(String ext) Converts this file to an UnknownFile (used for testing purposes).
Parameters:
Returns: UnknownFile Since: 08-23-2018 VCardFile toVCardFile() Returns VCard representation of this file. Returns invalid file if current file cannot be parsed as VCard Returns: VCardFile Since: 12-12-2011 |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Copyright © 2006 - 2024, ContractPal, Inc. All rights reserved. | API Date: Nov 22, 2024 11:54 AM |