Notizie su Spreadsheets

Crea elenchi dipendenti con le funzioni dinamiche di Excel

Febbraio 6, 2024
Scopri come utilizzare elenchi a discesa a cascata in MESCIUS Document Solutions for Excel utilizzando C#.NET, in modo da modificare un elenco in base a un altro.

Document Solutions for Excel, .NET Edition (DsExcel) by MESCIUS is a powerful server-side spreadsheet API designed for .NET environments. It allows you to create, load, modify, and convert Excel files without requiring Microsoft Excel itself. Document Solutions for Excel boasts a high-speed, low-footprint design, meaning efficient performance and streamlined integration into your applications. The intuitive interface mirrors Excel's object model, simplifying development for tasks like generating reports, manipulating data, and visualizing information with charts and formatting.

Spreadsheets often require dynamic relationships between dropdowns. Imagine choosing a customer from one dropdown, automatically triggering another dropdown to display only their relevant order IDs. This "cascading" functionality streamlines data navigation and fosters deeper analysis, allowing you to drill down into specific order details with ease.

In this blog post, MESCIUS Product Specialist Paarisha Rana demonstrates how to use DsExcel to create master and dependent dropdown lists programmatically. Steps include:

  • Initializing the Workbook and getting the Worksheet
  • Getting the unique list of customer names
  • Creating the master dropdown
  • Fetching the unique order IDs and populating the dependent dropdown
  • Populating the Worksheet with the order data

Read the complete blog and get started leveraging Excel's powerful capabilities in your own applications using Document Solutions for Excel.

Document Solutions for Excel is licensed per developer for either one distribution location or unlimited distribution locations. Licenses are perpetual, and include a one year subscription for all software releases (including hotfixes and major releases) plus Platinum Support. See our Document Solutions for Excel, .NET Edition licensing page for full details.

Learn more about Document Solutions for Excel, .NET Edition.

Metti in evidenza i dati che soddisfano condizioni specifiche

Febbraio 2, 2024
La formattazione condizionale evidenzia visivamente i punti dati chiave del foglio di calcolo, le tendenze e le anomalie, accelerando l'analisi e il processo decisionale.

Conditional formatting in spreadsheets automates the visual highlighting of cells or ranges based on predefined criteria. This functionality aids data analysis by rapidly drawing attention to specific values, ranges, or text entries. By employing color scales, gradients, or text changes, conditional formatting helps users identify patterns, exceptions, and trends within large datasets, streamlining the interpretation and communication of key insights.

Several JavaScript spreadsheet controls offer conditional formatting including:

  • Telerik Spreadsheet jQuery (part of Kendo UI) allows customizable cell formatting, including number, date/time, styles, and conditional formatting by setting a color and a condition to the format string.
  • SpreadJS by MESCIUS (formerly GrapeCity) supports conditional formatting in cells with several conditional rule types to choose from such as average, cell value, duplicate, formula, specific text and more.
  • Infragistics Spreadsheet Angular (part of Infragistics Ignite UI) allows you to conditionally format the background and font settings of cells in a worksheet based on predefined criteria such as average, blank, value, or date.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) lets you highlight a cell or a range of cells with a certain color based on applied conditions, and showcases data with data bars, color scales, and icon sets.

For an in-depth analysis of features and price, visit our comparison of JavaScript spreadsheets.

Compare JavaScript Spreadsheets

Esporta fogli di calcolo in PDF in .NET

Gennaio 26, 2024
La conversione di dati di un foglio di calcolo in PDF garantisce una visualizzazione coerente su tutte le piattaforme, rendendolo ideale per la condivisione e l'archiviazione.

PDF export functionality allows users to convert spreadsheets into PDF format, preserving the layout and formatting of the data. By seamlessly translating your data into a universally accessible format, you ensure colleagues, clients, and stakeholders can readily view and interpret your work without needing proprietary software. Choose from flexible options like exporting specific sheets, customizing page layouts, and enhancing accessibility for optimal visual presentation and impact. Whether for reports, invoices, or internal analyses, PDF export empowers a professional workflow with streamlined data dissemination.

Several .NET Spreadsheet components include support for exporting as PDF files, including:

For an in-depth analysis of features and price, visit our comparison of .NET Spreadsheet components.

Compare .NET Spreadsheet Components

Gestisci e automatizza le attività dei fogli di calcolo in .NET 8

Gennaio 23, 2024
Aspose.Cells for .NET V24.1 aggiunge il supporto per .NET 8, offrendo agli sviluppatori funzionalità di automazione dei fogli di calcolo ininterrotte.

Aspose.Cells for .NET is a robust programming library that empowers developers to manipulate, automate, and convert spreadsheets within their .NET applications. It eliminates dependence on Microsoft Excel while providing comprehensive control over data, formatting, charts, and even conversion to various file formats like PDF, JSON, and image formats, making it a powerful tool for streamlining spreadsheet-related tasks across platforms and environments.

The Aspose.Cells for .NET V24.1 release adds support for .NET 8. This allows developers to enjoy the performance boosts, enhanced cross-platform compatibility, and new APIs in the latest version of Microsoft's popular development framework.

To see a full list of what's new in Aspose.Cells for .NET 24.1, see our release notes.

Aspose.Cells for .NET is offered as Developer Small Business, Developer OEM, Site Small Business, and Site OEM licenses, catering to a range of business needs. Licenses are perpetual, and include 1 year of support and maintenance. Subscription renewals are also available. See our Aspose.Cells for .NET licensing page for full details.

Aspose.Cells for .NET is available to buy in the following products:

Costruisci fogli di calcolo localizzati in Angular

Gennaio 19, 2024
L'adattamento dell'applicazione del foglio di calcolo a diverse aree geografiche la rende più accessibile e facile da usare per un pubblico globale.

In spreadsheet controls, localization refers to adapting the user interface and functionality to different languages and cultural contexts. This involves translating static text like menu labels and buttons, formatting dates and numbers according to regional conventions, and even adjusting features like formula syntax to match users' expectations. Effective localization ensures intuitive interaction for global audiences, boosting user adoption and enhancing the overall spreadsheet experience.

Several Angular spreadsheet controls support localization including:

  • SpreadJS by MESCIUS (formerly GrapeCity) enables developers to streamline localization with rich formatting options, multi-language support, and built-in translation tools for Angular spreadsheets.
  • Telerik Excel Export (part of Kendo UI) allows you to simplify localization with built-in Excel formatting and right-to-left language support for Angular spreadsheet exports.
  • Jspreadsheet Pro is a front-end component, providing a datagrid that integrates with Angular. It features spreadsheet controls and the functionality to translate the datagrid interface and formula names.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) provides high performance and seamless RTL rendering for localized Angular spreadsheets with flexible APIs.

For an in-depth analysis of features and price, visit our Angular Spreadsheet Controls comparison.

Compare Angular Spreadsheet Controls