Spreadsheetsのニュース

C#とVB.NETを使用してExcelでテキストを列に分割

11月 11, 2024
Spread.NET by MESCIUSを使用すると、アプリケーションは、プログラムまたはランタイムウィザードを使用して、テキストを複数の列に分割可能

Spread.NET by MESCIUS is a versatile spreadsheet component for .NET applications, enabling developers to integrate Excel-compatible functionalities into Windows Forms, WPF, ASP.NET, and Blazor. 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.

In this blog post, MESCIUS Product Marketing Specialist Mackenzie Albitz shows you how to use Spread.NET to efficiently manage data within your applications when you encounter text that needs to be split into columns. Steps include:

  • Programmatically splitting Text to Columns in C# and VB.NET:
    • TextToColumns Method
    • TEXTSPLIT Function
  • Invoking the Text to Columns Wizard in WinForms Apps:
    • Programmatically Invoking the Convert Text to Columns Wizard
    • No-Code Solution with Spread Designer and Ribbon Control

Detailed sample code is included that you can use as a foundation for your applications.

Read the full blog to get started using this powerful capability of Spread.NET.

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.

複雑な数式をより正確に計算

10月 28, 2024
ONLYOFFICE Docs v8.2では、循環参照の反復計算や、エラーを引き起こす可能性のあるその他の高度な式を追加

ONLYOFFICE Docs is a comprehensive online editor, allowing users to create text documents, spreadsheets, presentations, and forms. It enables your users to edit, share, and collaborate on documents online in their preferred browser, within your own application. It is fully compatible with OOXML (Office Open XML) formats and supports popular Microsoft Office and other document formats such as CSV, DOC, DOCX, EPUB, HTML, ODP, ODS, ODT, PDF, PPT, PPTX, RTF, TXT, XLS, and XLSX.

The ONLYOFFICE Docs v8.2 update adds support for performing iterative calculations. This enables formulas to be repeatedly recalculated until a specific, stable result is reached or a set number of attempts is made. By setting iteration limits and defining acceptable precision levels, iterative calculations enable users to control the number of recalculations, allowing the formula to reach an approximation or convergence point that serves as the final value. This process is particularly useful when dealing with circular references, where a formula refers to its own cell either directly or through a sequence of references involving other cells. Without iterative calculations, such formulas would produce errors, as they would require an infinite loop of recalculations. This is widely used in scenarios requiring complex dependencies, such as financial projections, engineering simulations, and scientific modeling.

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

ONLYOFFICE Docs is licensed by the number of simultaneous document connections and is available as an annual license with 1 year support and upgrades. See our ONLYOFFICE Docs licensing page for full details.

For more information, see our ONLYOFFICE Docs product page.

セルをマージしてスプレッドシートの整理を強化

10月 28, 2024
セルを結合すると、適切に構造化されたレイアウトでスプレッドシートの読みやすさが向上し、テーブルが洗練されたプロフェッショナルな外観に。

Cell merging is a spreadsheet feature that combines two or more adjacent cells into a single, larger cell, creating a unified space for data. This is particularly useful for creating visually organized and readable spreadsheets, allowing headers to span multiple columns or rows, enhancing clarity and alignment in complex data sets. By merging cells, users can create more structured layouts, making the data presentation cleaner and often easier to understand at a glance. For example, in financial reporting or project tracking sheets, merging cells can emphasize titles, group categories, or highlight specific sections of data, adding visual polish. It can also help when building dashboards, forms, and reports where visual hierarchy and structured information flow are essential for end-user readability and comprehension.

Several React spreadsheet controls offer the ability to merge cells including:

  • SpreadJS by MESCIUS allows users to merge spreadsheet cells, enabling a customizable and organized data layout within web applications.
  • Jspreadsheet Pro offers a straightforward cell merging experience that enhances the presentation of grouped or consolidated data in a spreadsheet format.
  • Infragistics Spreadsheet React (part of Ignite UI by Infragistics) provides flexible cell merging capabilities, helping developers create visually cohesive data arrangements.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) supports cell merging for enhanced readability and structure in complex data sheets.

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

Compare React Spreadsheet Controls

テーマでスプレッドシートをカスタマイズ

10月 18, 2024
テーマを使用して、スプレッドシートをニーズに合わせて調整し、ブランドガイドラインに沿ってまとまりのあるプロフェッショナルな外観を作成します。

Theming provides users with the ability to customized the visual elements like colors, fonts, and layouts to create a consistent and visually appealing user interface to their spreadsheets. By applying themes, you can enhance the overall aesthetic of your spreadsheet, improve readability, and make it more engaging for users. Themes can also help to align your spreadsheet with your brand guidelines, creating a cohesive and professional look.

Several ASP.NET Core spreadsheet controls offer support for applying themes including:

  • DevExpress ASP.NET Core Spreadsheet (part of DevExpress ASP.NET and Blazor) empowers you to tailor the spreadsheet's look with pre-built themes or craft custom color schemes for a seamless user experience.
  • Telerik ASP.NET Core Spreadsheet (part of Telerik UI for ASP.NET Core) provides built-in themes to customize the spreadsheet's appearance, ensuring alignment with your application's overall design.
  • Syncfusion ASP.NET Core Spreadsheet (part of Syncfusion Essential Studio Enterprise) facilitates thematic customization of the spreadsheet control, enabling you to create a visually cohesive and user-friendly interface.

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

Compare ASP.NET Core Spreadsheet Controls

Excel XLSX APIライブラリをJavaアプリに追加

10月 18, 2024
Document Solutions for Excel, Java Editionを使用して、JavaアプリケーションからExcelワークブックを開き、更新し、保存

Document Solutions for Excel, Java Edition is a high-speed Java Excel spreadsheet API library that that enables you to programmatically create, edit, import, and export Excel XSLX spreadsheets from Java applications. Develop in Java for Windows, Linux, and Mac and deploy to the Cloud, including Azure, AWS, and AWS Lambda. The interface-based API is modeled on Excel's document object model, which means you can import, calculate, query, generate, and export any spreadsheet scenario, create full reports, sort/filter tables, sort/filter pivot tables, dashboard reports, add charts, sparklines, conditional formats, import and export Excel templates and also convert spreadsheets to PDF, HTML, or an Image type.

In this blog post, MESCIUS Product Marketing Specialist Mackenzie Albitz takes you through the steps for adding an Excel API to your Java application, including:

  • Creating a Java Application Including the Java Excel API
  • Creating Excel Tables Using the ITable Interface, which includes...
    • Initializing Table Data
    • Adding the Excel Tables
    • Applying Table Formulas
    • Setting the Table's Row Height and Column Width
  • Saving the Java Excel Workbook

Detailed instruction and sample code are included.

Read the full blog to learn how to deploy spreadsheets at scale across Java applications.

Document Solutions for Excel, Java Edition 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, Java Edition licensing page for full details.

Learn more on our Document Solutions for Excel, Java Edition product page.