Neuigkeiten zu Spreadsheets

Vereinfachen Sie die Diagrammerstellung mit dem neuen DataCharts-Add-on

Dezember 19, 2024
SpreadJS v18 integriert ein neues optionales Add-on für die Bindung von Diagrammen an externe Daten für eine dynamische und flexible Visualisierungen von Tabellenkalkulationen.

SpreadJS by MESCIUS is a high-performance JavaScript spreadsheet component designed to seamlessly integrate Excel-like functionality into web applications. It empowers developers to deliver robust spreadsheet experiences within their applications, complete with features like data import/export, complex formulas, conditional formatting, and extensive customization options. To extend its capabilities, SpreadJS offers a variety of optional add-ons, such as tools for reporting, charting, and data management. SpreadJS caters to a wide range of use cases, from financial modeling and data analysis to project management and interactive dashboards, ultimately allowing developers to build feature-rich and user-friendly web applications.

SpreadJS v18 introduces the DataCharts Add-On, a powerful new feature that lets you bind charts directly to external data managed by the Data Manager, eliminating the need to embed data within the workbook. This innovation streamlines workflows by reducing redundancy, simplifying updates, and enabling dynamic charting for both standalone spreadsheets and reports. For users of the ReportSheets Add-On, the DataCharts Add-On is seamlessly integrated, enhancing report creation with interactive, data-driven visuals. Developers seeking a flexible solution for external data visualization in other contexts can license the DataCharts Add-On separately, making it ideal for projects that demand adaptable, visually engaging charts.

For more information see our release notes.

SpreadJS is licensed per developer and includes 1 Year Maintenance (major and minor version releases and unlimited support phone calls). SpreadJS requires an Annual or Perpetual Deployment License. The optional Add-ons are available at an additional cost, and require a SpreadJS license. See our SpreadJS licensing page for full details.

For more information, visit our SpreadJS product page.

Verbessern von Was-wäre-wenn-Analyse durch die Automatisierung der Szenarien

Dezember 16, 2024
Document Solutions for Excel v8.0.0 bietet eine programmatische Unterstützung für Was-wäre-wenn-Analysen mit Szenarien und verbessert so die Entscheidungsfindung in Excel.

Document Solutions for Excel by MESCIUS is a comprehensive tool designed to streamline the creation, management, and distribution of Excel-based reports and documents. It simplifies tasks such as generating dynamic templates, automating complex data processing workflows, and ensuring consistency across reports. By integrating seamlessly with Excel, it caters to organizations needing efficient, scalable solutions for financial reporting, data analysis, and operational documentation. Its key benefits include reducing manual effort, minimizing errors, and improving productivity, making it ideal for finance teams, analysts, and any professionals managing high-volume data tasks.

The Document Solutions for Excel v8.0.0 update enhances what-if analysis capabilities by introducing programmatic support for scenarios, enabling developers to create, manage, and apply multiple sets of input values to dynamically assess their impact on spreadsheet calculations. This new functionality allows precise control over scenarios, including defining changing cells, locking or hiding scenarios for security, and modifying or deleting them as needed. Developers can seamlessly integrate scenario management into workflows, automate complex forecasting tasks, and ensure secure collaboration on protected worksheets. These enhancements streamline decision-making processes and provide robust tools for developing data-driven applications.

To see a full list of what's new in version 8.0.0, see our release notes.

Document Solutions for Excel is licensed per developer and is available in several license options for differing distribution needs. Team licenses are also available for multiple developers within the same organization. See our Document Solutions for Excel, .NET Edition licensing page for full details.

Document Solutions for Excel is available to buy in the following products:

Nutzen Sie KI zum Übersetzen von Zellinhalten in Tabellenkalkulationen

Dezember 12, 2024
Das Pine AI Excel Add-In ermöglicht es Benutzern, Tabellenkalkulationsdaten mühelos zwischen beliebigen Sprachen zu übersetzen und dabei die ursprüngliche Struktur der Daten beizubehalten.

Pine AI Excel Add-In, developed by Pinexl, integrates OpenAI's ChatGPT into Microsoft Excel, enabling users to generate, debug, and interpret complex formulas and Visual Basic for Applications (VBA) code by simply describing their requirements. This tool enhances productivity by automating tasks such as data analysis, summarization, transformation, and translation directly within Excel spreadsheets. For instance, users can extract specific information from unstructured data, fill in missing details like country names based on city data, and translate text without leaving the Excel environment. By streamlining these processes, Pine AI reduces the time spent on manual data manipulation and extensive online research, making it a valuable asset for professionals seeking to optimize their workflow within Excel.

Using the Pine AI Excel Add-In, translating spreadsheet cell content is simple and seamless. Users can select the data they wish to translate directly within Excel, specify the target language, and let Pine AI handle the rest. The translated content is generated and placed back into the desired cells, maintaining the original format. This eliminates the need to use external tools, streamlining multilingual workflows and enhancing productivity for data analysis or global collaboration.

Pine AI Excel Add-In is licensed per user on an annual subscription basis. To continue using the software you will need an active subscription. See our Pine AI Excel Add-In licensing page for full details.

Learn more on our Pine AI Excel Add-In product page.

Verwandeln Sie Tabellenkalkulationen in hochwertige PDFs

Dezember 6, 2024
Spread.NET 18 bietet hochauflösende PDF-Exporte mit Excel-kompatiblen Funktionen und erweiterten Darstellungsoptionen.

Spread.NET by MESCIUS is a versatile spreadsheet component for .NET applications, enabling developers to integrate Excel-compatible functionalities into Windows Forms, WPF and ASP.NET. With features like advanced data visualization, pivot tables, conditional formatting, and customizable formulas, Spread.NET handles large data sets efficiently and allows seamless Excel import/export. This tool is ideal for applications needing robust data analytics and reporting, such as financial software and business intelligence solutions, enhancing user experience with a familiar spreadsheet interface.

The Spread.NET 18 update enhances PDF export capabilities by delivering high-resolution outputs with improved image quality and rendering precision. This update aligns closely with Excel-compatible printing features, ensuring accurate representation of rich text, flat style modes, transparent shapes and header/footer images in PDF documents. Developers can now save individual sheets, entire workbooks or directly print to PDF, providing greater flexibility and efficiency. With these improvements, the PDF export functionality meets professional-grade standards, making it a reliable tool for creating polished, high-quality outputs directly from .NET spreadsheets.

To see a full list of what's new in version 18, see our release notes.

Spread.NET is licensed per developer and is available as a Perpetual License with a 12 month support and maintenance subscription. We can supply any Spread.NET license including new licenses, maintenance renewals, and upgrade licenses. See our Spread.NET licensing page for full details.

For more information, visit our Spread.NET product page.

Optimieren der gemeinsamen Nutzung von Daten mit XLSX Export

Dezember 3, 2024
Konvertieren Sie Tabellenkalkulationsdaten in das gängige Dateiformat Microsoft Excel zur Gewährleistung der Kompatibilität und der Benutzerfreundlichkeit über verschiedene Plattformen hinweg

Spreadsheet component with XLSX export functionality allow users to output spreadsheet data into the industry standard Excel-compatible format. This feature is especially useful for applications where data needs to be analyzed, shared, or integrated into external workflows. By enabling XLSX export, users can download structured data directly from the web application in a format widely supported across platforms and software. The benefits of this functionality include maintaining data accuracy, preserving formatting, and supporting large datasets with advanced features like formulas, filters, and charts. Use cases for XLSX export range from financial dashboards and inventory management systems to data analytics platforms and collaborative tools, offering users the flexibility to work offline or share data in a familiar format.

Several React spreadsheet components offer XLSX export, including:

  • Telerik Spreadsheet React (part of KendoReact) lets you effortlessly export your spreadsheet data to XLSX format, ensuring seamless integration with Excel.
  • SpreadJS by MESCIUS allows you to output spreadsheet to XLSX format, enabling flexible data sharing and analysis across various platforms and tools.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) offers XLSX export, providing a convenient way to share data.

For an in-depth analysis of features and price, visit our React spreadsheet controls comparison.

Compare React Spreadsheet Controls