{"id":814,"date":"2014-05-19T12:38:02","date_gmt":"2014-05-19T12:38:02","guid":{"rendered":"http:\/\/mindfusion.eu\/blog\/?p=814"},"modified":"2021-01-14T11:09:58","modified_gmt":"2021-01-14T11:09:58","slug":"mindfusion-spreadsheet-import-and-export","status":"publish","type":"post","link":"https:\/\/mindfusion.dev\/blog\/mindfusion-spreadsheet-import-and-export\/","title":{"rendered":"MindFusion.Spreadsheet: Import and Export"},"content":{"rendered":"

The following scheme illustrates the file formats supported by MindFusion.Spreadsheet for WinForms:<\/p>\n

\"spreadsheet-formats\"<\/a><\/p>\n

Importing<\/strong><\/p>\n

MindFusion.Spreadsheet can load data from CSV (comma-separated values), XLSX (Office Open XML), ODS (OpenDocument Spreadsheet), and its native binary and XML formats. The files are imported through a set of importer classes: CsvImporter for CSV, ExcelImporter for XLSX, and CalcImporter for ODS. To import a file, create an instance of the respective importer class, set the necessary properties, and call its Import method. The following code demonstrates how to import a workbook from an existing XLSX file:<\/p>\n

var excelImporter = new ExcelImporter();\nexcelImporter.Import(workbook, @\"d:\\workbook.xlsx\");<\/pre>\n
Importing from CSV can be further facilitated through the use of a built-in CsvImportForm. The form provides the user interface to enter various options and preview the data before it is actually imported.<\/p>\n
Exporting<\/strong><\/p>\n
MindFusion.Spreadsheet can export data to a variety of formats, including image, PDF, CSV, XLSX, ODS, HTML and MHTML. In addition the workbooks can be previewed and printed to paper and XPS. The workbooks and worksheets are exported through a set of exporter classes: ImageExporter for images, PdfExporter for PDF, CsvExporter for CSV, ExcelExporter for XLSX, CalcExporter for ODS, HtmlExporter for XHTML, and so on. Printing is done through the WorkbookPrinter class. To export a workbook, create an instance of the respective exporter class, set the necessary properties, and call the Export method. The following code demonstrates how to export a workbook to ODS:<\/p>\n
var calcExporter = new CalcExporter();\ncalcExporter.Export(workbook, @\"c:\\mysheet.ods\");<\/pre>\n
The following image illustrates a workbook exported to an XHTML file using the HtmlExporter class:<\/p>\n
\"spreadsheet-xhtmlexport\"<\/a><\/p>\n
Additional information about the importing and exporting capabilities of MindFusion.Spreadsheet can be found in the online documentation of the component:<\/p>\n
http:\/\/www.mindfusion.dev\/onlinehelp\/spreadsheetwinforms\/index.htm?Importing.htm<\/a>
\nhttp:\/\/www.mindfusion.dev\/onlinehelp\/spreadsheetwinforms\/index.htm?Exporting_0.htm<\/a><\/p>\n
The trial version of MindFusion.Spreadsheet for WinForms can be downloaded from here:<\/p>\n
Download MindFusion.Spreadsheet for WinForms Trial Version<\/a><\/p>\n
About MindFusion.Spreadsheet for WinForms<\/em>: A powerful .NET spreadsheet component with great capabilities for editing, styling and formatting large amounts of data.<\/p>\n","protected":false},"excerpt":{"rendered":"
The following scheme illustrates the file formats supported by MindFusion.Spreadsheet for WinForms: Importing MindFusion.Spreadsheet can load data from CSV (comma-separated values), XLSX (Office Open XML), ODS (OpenDocument Spreadsheet), and its native binary and XML formats. The files are imported through … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[163],"tags":[171,165,31,97,219,136,218,173,30,220,164,166,192,217,172],"class_list":["post-814","post","type-post","status-publish","format-standard","hentry","category-spreadsheet","tag-csv","tag-excel","tag-export","tag-html","tag-image","tag-import","tag-mhtml","tag-ods","tag-pdf","tag-png","tag-spreadsheet-2","tag-workbook","tag-worksheet","tag-xhtml","tag-xlsx"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p3RlKs-d8","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/mindfusion.dev\/blog\/wp-json\/wp\/v2\/posts\/814","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mindfusion.dev\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mindfusion.dev\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mindfusion.dev\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/mindfusion.dev\/blog\/wp-json\/wp\/v2\/comments?post=814"}],"version-history":[{"count":6,"href":"https:\/\/mindfusion.dev\/blog\/wp-json\/wp\/v2\/posts\/814\/revisions"}],"predecessor-version":[{"id":2492,"href":"https:\/\/mindfusion.dev\/blog\/wp-json\/wp\/v2\/posts\/814\/revisions\/2492"}],"wp:attachment":[{"href":"https:\/\/mindfusion.dev\/blog\/wp-json\/wp\/v2\/media?parent=814"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mindfusion.dev\/blog\/wp-json\/wp\/v2\/categories?post=814"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mindfusion.dev\/blog\/wp-json\/wp\/v2\/tags?post=814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}