Spreadsheet API.

  • UV
  • UD
  • D3
  • QM

Create OpenXML Documents.

Do you export to comma separated or delimited files for your users to import data into Excel or another OpenXML compatible spreadsheet program?

mvSpread provides a simple Basic API to work directly with OpenXML files in real time including advanced features such as styles, data types and charting.

Low Level Control.

The mvSpread API adds a library of functions to your Basic code that expose OpenXML features: the native format used by Microsoft Excel and other spreadsheet applications.

Using the mvSpread API you can open, navigate and import data from existing spreadsheets, can create new workbooks and edit existing content, all from within your MultiValue application.

Work Easily with Data.

  • List, add, insert, rename, copy or delete worksheets.
  • Get and set individual cells or ranges of cells.
  • Use matrix coordinates or A1 naming.
  • Add cell formulae, links and comments.
  • Convert between OpenXML and MultiValue data types.
  • Merge or fetch bulk data.
  • Clear, insert or delete columns and rows.

Apply Styling

Easily apply styles to cells or ranges, with control over fonts, backgrounds and gradients, colours and border styling, cell alignments and merging, word wrap and rotation.

Or use tables to apply the named styles built into OpenXML including summary column operations.


mvSpread Tables

Merge Data with Commands

For simple exports you can populate a new or existing spreadsheet using a single merge command.

Merges can be run programatically giving developers complete control over the data that is provided, or from an EXCEL.MERGE TCL command that uses enquiry language syntax to populate a spreadsheet through dictionary items.


mvPDF Watermark


Application Integration

mvSpread uses a real time service to expose the OpenXML API, so you can easily integrate it with email and distribution software such as mvDistributor.

Supported Platforms

Because mvSpread runs as a real time service over a socket connection, you can run the mvSpread API from databases hosted on Windows and UNIX platforms.