Noticias sobre Spreadsheets

Importe y exporte XLSX de Excel usando Blazor

Febrero 18, 2025
SpreadJS de MESCIUS le permite importar y exportar archivos de Excel en su aplicación Blazor, aportando una potente funcionalidad de hoja de cálculo a la web.

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

In this blog post, MESCIUS Product Manager Kevin Ashley shows you how to use the powerful and extensible SpreadJS component to import and export Excel files. Steps include:

  • Creating the Blazor Application
  • Creating the SpreadJS Component
  • Adding SpreadJS Excel Import and Export
  • Adding the SpreadJS component to Home Page

Detailed source code is included and you can also download the sample app.

Read the full blog to get starting working directly with Excel files in your Blazor applications.

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.

Inserte sin problemas columnas de hojas de cálculo bajo demanda

Febrero 11, 2025
Permita a los usuarios agregar columnas al instante, transformando las hojas de cálculo estáticas en herramientas dinámicas que se adaptan a requisitos de datos en evolución.

The option to insert columns in a spreadsheet gives users the flexibility to expand or reorganize their data as needed. This functionality allows for seamless adjustments, making it easier to add new data fields or restructure existing information. By enabling column insertion, users can customize their data views for more effective analysis and manipulation. This not only enhances productivity but also delivers a more responsive and adaptable interface that evolves with their data requirements, improving the overall user experience.

Several Angular spreadsheet controls offer the ability to insert columns including:

  • SpreadJS by MESCIUS empowers users to dynamically insert columns, enhancing data visualization and manipulation within their Angular applications.
  • Jspreadsheet Pro facilitates seamless column insertion, enabling flexible data organization and adaptation to evolving needs in Angular spreadsheets.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) allows dynamic column insertion, providing a robust solution for building interactive apps.

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

Compare Angular Spreadsheet Controls

Celebramos 3 años de colaboración con EPPlus

Febrero 11, 2025
ComponentSource y EPPlus Software colaboran desde 2022 para ofrecer potentes componentes de hojas de cálculo a desarrolladores de todo el mundo.

ComponentSource and EPPlus Software have enjoyed a successful three-year partnership, dedicated to providing high-quality tools to developers around the world. This collaboration reflects their shared mission to empower developers with innovative solutions that boost productivity and support the creation of reliable, high-performance applications.

EPPlus Software is the creator of EPPlus, a widely used .NET library for managing Office Open XML spreadsheets. Offering advanced features such as styling, charts, formulas, and pivot tables, it simplifies data processing and reporting. By adopting EPPlus, organizations can streamline spreadsheet-driven workflows, improve accuracy, and reduce costs.

As a leading distributor of software components and development tools, ComponentSource has helped to expand EPPlus Software’s global reach. This collaboration has brought tangible benefits to the developer community, making cutting-edge spreadsheet tools readily available. As we celebrate this three-year milestone, we look forward to strengthening our partnership and continuing to deliver  innovative solutions that drive developer success on a global scale.

Learn more about EPPlus Software.

Optimice la gestión de datos con hojas de cálculo

Febrero 6, 2025
Agregue funcionalidad similar a Excel a sus aplicaciones con componentes de hojas de cálculo interactivas que admiten fórmulas, formatos y más.

Modern spreadsheet components bring the power of Excel-like functionality to web applications, enabling users to create, edit, and manipulate data within an interactive grid. These components typically support formulas, formatting, data validation, and seamless integration with various data sources. Advanced features such as pivot tables, conditional formatting, and charting allow users to analyze and visualize data efficiently. Designed for performance and scalability, these spreadsheet controls cater to both enterprise applications and smaller projects that require robust data processing capabilities.

Several ASP.NET Core UI suites offer spreadsheet components including:

  • DevExpress ASP.NET and Blazor offers a high-performance spreadsheet component with extensive formula support, charting, and seamless document import/export capabilities.
  • Telerik UI for ASP.NET Core provides a feature-rich spreadsheet control with Excel-like filtering, and sorting, ensuring smooth data management within web applications.
  • Infragistics Ignite UI delivers a powerful spreadsheet component with support for formulas, and styling, optimized for high-performance applications.
  • Syncfusion Essential Studio Enterprise includes a robust spreadsheet control with built-in functions, data binding, and client- and server-side processing for better performance.

For an in-depth analysis of features and price, visit our ASP.NET Core UI suites comparison.

Compare ASP.NET Core UI Suites

Importe y exporte archivos CSV con WinForms

Febrero 4, 2025
Utilice Spread.NET de MESCIUS para mejorar sus proyectos de WinForms con capacidades integradas de importación y exportación de hojas de cálculo de Excel en C# o VB.

Spread.NET helps you create spreadsheets, grids, dashboards, and forms. It includes a powerful calculation engine with 450+ functions and the ability to import and export Excel spreadsheets. Leverage the extensive .NET spreadsheet API and powerful calculation engine to create analysis, budgeting, dashboard, data collection and management, scientific, and financial applications.

In this blog post, MESCIUS Product Marketing Specialist Mackenzie Albitz guides you through the four essential steps to import and export Excel spreadsheets on your way to creating robust .NET WinForms spreadsheet applications with Spread.NET. These steps include:

  • Configure a .NET WinForms Spreadsheet Application
  • Import a CSV File into a .NET Spreadsheet
  • Convert a CSV File into an Excel XLSX File using C# or VB.NET
  • Export a .NET Spreadsheet Instance to a CSV File
  • Handle CSV Files with a UI Spreadsheet Ribbon Toolbar

Sample code is included in the blog and you can download the sample app in either C# or VB.

Read the full blog post to discover how to use the full capabilities of the Spread.NET WinForms component.

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.