Tag Archives: import

MindFusion.Spreadsheet: Import and Export

Posted on by

The following scheme illustrates the file formats supported by MindFusion.Spreadsheet for WinForms:

spreadsheet-formats

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 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:

var excelImporter = new ExcelImporter();
excelImporter.Import(workbook, @"d:\workbook.xlsx");

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.

Exporting

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:

var calcExporter = new CalcExporter();
calcExporter.Export(workbook, @"c:\mysheet.ods");

The following image illustrates a workbook exported to an XHTML file using the HtmlExporter class:

spreadsheet-xhtmlexport

Additional information about the importing and exporting capabilities of MindFusion.Spreadsheet can be found in the online documentation of the component:

http://www.mindfusion.eu/onlinehelp/spreadsheetwinforms/index.htm?Importing.htm
http://www.mindfusion.eu/onlinehelp/spreadsheetwinforms/index.htm?Exporting_0.htm

The trial version of MindFusion.Spreadsheet for WinForms can be downloaded from here:

Download MindFusion.Spreadsheet for WinForms Trial Version

About MindFusion.Spreadsheet for WinForms: A powerful .NET spreadsheet component with great capabilities for editing, styling and formatting large amounts of data.

Diagramming for Java, V4.0.5 Released

Posted on by

MindFusion has released a new version of its Diagramming library for Java. Here is an overview of the new features:

Resize of multiple nodes

The new version lets you resize multiple nodes simultaneously – just call Diagram.setAllowMultipleResize(true) to enable it. When enabled, dragging a corner or side adjustment handle of any node resizes all nodes in the selection.

Multiple selection of nodes.

Multiple selection of nodes.

VisioImporter Improvements

  • The Item argument of the VisioImportListener.importItem event handlers is now pre-set to a
    DiagramItem instance created for the imported Visio shape, letting you avoid parsing some standard data such as Bounds or Text.
  • A few bugs have been fixed

ZoomControl Improvements

  • Changing DiagramView.ZoomFactor now automatically updates the zoom control slider
  • the pan widget now fills the ZoomControl width or height instead of having fixed size.
  • setting ZoomControl’s width larger than its height makes the zoom slider horizontal.

We have also made a few API changes – read details here. The trial version is available for download from the following link:

Download MindFusion.Diagramming for Java Swing, V4.0.5 Trial

Technical support

MindFusion puts special effort in providing high quality technical support to all its clients and evaluators. You can post your questions about Diagramming for Java or any other of our components at the forum, help desk or at support@mindfusion.eu. All support inquiries are usually answered within hours of being received.

About Diagramming for Java Swing: MindFusion.Diagramming for Java Swing provides your Java application with all necessary functionality to create and customize a diagram. The library is very easy to integrate and program. There are numerous utility methods, rich event set, more than 80 predefined shapes. The tool supports a variety of ways to render or export the diagram, advanced node types like TreeView nodes, hierarchical nodes, tables, container nodes and many more. There are 15 automatic layouts, various input / output options and fully customizable appearance. A detailed list with JDiagram’s features is uploaded here. You can check the online demo to see some of the functionality implemented.

Diagramming for Java Swing is royalty free, there are no distribution fees. Licenses depend on the count of developers using the tool – check here the prices.

MindFusion.Diagramming for WinForms, V6.1.2

Posted on by

Diagramming for WinForms has just been released and adds various customer-requested features. Here is an overview:

Resize of multiple nodes

If you set the AllowMultipleResize property to true all nodes in the selection will be resized simultaneously when one of them is dragged by a corner or a side adjustment handle.

Selection of multiple nodes in a diagram built with FlowChart.NET

Selection of multiple nodes in a diagram built with FlowChart.NET

Visio2013Importer improvements

  • The Item argument of the ImportItem event handlers is now preset to a DiagramItem instance created for the imported Visio shape. You can either modify the item’s properties or set it to an instance of a different type.
  • several bugs have been fixed

Miscellaneous

  • LinkLabels are copied by the DiagramLink copy constructor and clipboard methods
  • Better LinkLabel positioning along Bezier links
  • DiagramView.ZoomFactor setter no longer automatically aligns its value to ZoomControl zoom steps. This avoids imprecise ZoomToFit results.
  • A few API changes were made.

You can read further details about this release at the news page in the Diagramming for WinForms forum. If you are willing to try the new version here is a link to download it:

Diagramming for WinForms, V6.1.2

If you have questions or run into problems using the component you can use the Diagramming for WinForms forum, the help desk or write us at support@mindfusion.eu. Our support team will be pleased to help you.

About MindFusion.Diagramming for WinForms: A programming component that provides any WinForms application with a full set of features for creating and customizing all types of diagrams, flowcharts, schemes, hierarchies, trees, graphs etc. The control provides numerous ways to save and load a diagram, six auxiliary controls and more than 10 automatic graph layout algorithms. Diagram elements include scrollable tables, container nodes, multi-segment arrows, custom diagram item types and many more. Further
details here.

Diagramming for WinForms is a royalty-free component, clients get 12 month upgrade subscription when buying a license. The source code is also available for purchase. Visit the buy page for a list with the current license prices.

Diagramming for Java, V4.0.4

Posted on by

MindFusion has released Diagramming for Java 4.0.4 Here is an overview of the new features:

Import of Visio 2013 files

You can use the new VisioImproter class to import *.vsdx files, created by Visio 2013. In order to use it, you must import the com.mindfusion.diagramming.importers namespace. The Import method has several overloads, which let you choose whether to import the diagram as a single Diagram whose content is merged from all imported pages or as a DiagramDocument whose pages correspond to the Visio pages. At this time VisioImporter supports the basic flowchart and data flow Visio stencils.

Import of OpenOffice Draw files

The new DrawImporter class can import .odg files, created by the OpenOffice Draw vector graphics editor. In order to use it, you must import the com.mindfusion.diagramming.importers namespace. DrawImporter supports shapes from the General and Flowchart shape palettes in Draw. You can choose among several overloads of the Import method to import the OpenOffice drawing into a DiagramDocument whose pages correspond to the Draw pages, or into a single Diagram whose content is merged from all imported pages.

Miscellaneous

  • The AutoSnapToNode property allows links to be snapped to nodes from a distance
  • Use the new RoundedLinks and RoundedLinksRadius properties to draw arcs at the joints of Cascading and Polyline links’ segments.
  • Several new shapes for better compatibility with Visio 2013 basic stencil were added: RightTriangle, Decagon, Trapezoid, Star4Pointed, Star5Pointed, Star6Pointed, Star7Pointed, Star16Pointed, Star24Pointed, Star32Pointed, Donut, Plaque.
The new predefined node shapes.

The new predefined node shapes.

Further details about the new release are posted at the JDiagram forum. You can download the control and test yourself its performance and functionality. Here is a direct link to the trial version:

Download MindFusion.Diagramming for Java Swing, V4.0.4

Technical support

MindFusion puts special effort in providing high quality technical support to all its clients and evaluators. You can post your questions about Diagramming for Java or any other of our components at the forum, help desk or at support@mindfusion.eu. All support inquiries are usually answered within hours of being received.

About Diagramming for Java Swing: MindFusion.Diagramming for Java Swing provides your Java application with all necessary functionality to create and customize a diagram. The library is very easy to integrate and program. There are numerous utility methods, rich event set, more than 80 predefined shapes. The tool supports a variety of ways to render or export the diagram, advanced node types like TreeView nodes, hierarchical nodes, tables, container nodes and many more. There are 15 automatic layouts, various input / output options and fully customizable appearance. A detailed list with JDiagram’s features is uploaded here. You can check the online demo to see some of the functionality implemented.

Diagramming for Java Swing is royalty free, there are no distribution fees. Licenses depend on the count of developers using the tool – check here the prices.

MindFusion.WinForms Pack 2014.R1

Posted on by

MindFusion has just released a new version of its pack of components for WinForms. Here is an overview of the major new features:

Support for Visual Studio 2013

You can now install a toolbox palette for the components in VS2013 as well choose to install VS2013 sample projects.

Spreadsheet-16x16MindFusion.Spreadsheet

MindFusion.Pack for WinForms boasts a brand new component – MindFusion.Spreadsheet for WinForms. It’s a powerful tool for creating complex spreadsheets of all type. The control supports formulas, cell spanning, various import/export options, images and a long list of style & appearance settings. Read more about MindFusion.Spreadsheet for WinForms here.

A spreadsheet created with the new component.

A spreadsheet created with the new component.

diagram16x16MindFusion.Diagramming

Import of Visio 2013 Fies

The new Visio2013Importer class can import .vsdx files created by Visio 2013. The class is part of the MindFusion.Diagramming.Import.Visio.dll assembly and you must reference it if you want to use the importer in your project. The class provides various overloads of the Import method, which let you choose how the diagram is imported – as a DiagramDocument, whose pages correspond to the Visio drawing pages or as a single Diagram, whose content is merged from all imported pages.

Zoom control

The ZoomControl class lets you interactively change the zoom level and scroll position of a DiagramView. It is very easy to set it – place the Zoom control anywhere over a DiagramView and set the control’s Target property to that view. The control provides various customization properties like ZoomStep, ScrollStep, Fill, BorderColor, CornerRadius and more.

Miscellaneous

  • You can change the active page in a TabbedDiagramView control with the arrow buttons When AllowRenamePages is enabled, DiagramPage titles can be renamed interactively by clicking the active tab in a TabbedDiagramView.
  • Several new shapes added for better compatibility with Visio 2013 basic stencil: RightTriangle, Decagon, Trapezoid, Star4Pointed, Star5Pointed, Star6Pointed, Star7Pointed, Star16Pointed, Star24Pointed, Star32Pointed, Donut, Plaque.
  • and more.
The new predefined node shapes.

The new predefined node shapes.

Calendar-16x16MindFusion.Scheduling

Improved support for non-Gregorian calendars

MindFusion.Scheduling now provides better support for non-Gregorian calendars, such as Hijri. The control can also display a Persian calendar through the new PersianCulture. Use the Culture property of the Calendar class to specify the calendar to be used by the control.

New holiday provider

You can use the new AustraliaHolidayProvider (available in the MindFusion.HolidayProviders.dll assembly) to supply the major holidays in Australia for a specific time interval.

A sample calendar with holidays.

A sample calendar with holidays.

The trial version is available for direct download from this link:

Download MindFusion.WinForms Pack 2014.R1

If you run into problems with any of the components, please let us know. We shall be glad to assist you. MindFusion is proud with its excellent technical support – the majority of the questions are answered within hours of receiving them.

About MindFusion.WinForms Pack: A set of five WinForms programming components that provide your application with a rich choice of diagramming, charting, scheduling, mapping, reporting and gauge features. The tools are very easy to implement and use. They boast intuitive API and various step-by-step tutorials to get you started. Both online and offline documentation is available. A sample browser presents you with all the samples for each control to let you easily navigate to what you need. You can check some of the features of each component right now if you look at the online demos:

Visit the features – page of the components for more information about their capabilities:

You can check the prices and licensing scheme here. All components are royalty-free.