Tag: #xlsx
8 articles
-
Import an Excel File into a DataGridView in VB.NET — Without Office or OLEDB
The usual OLEDB route stops on any PC without the Access Database Engine, and it guesses each column's type from the first few rows, so values that don't fit arrive empty. This VB.NET module reads an .xlsx file into a typed DataTable and shows it in a DataGridView: title rows above the header, dates, merged cells, leading zeros and the total row underneath are all handled. Code for ReoGrid V5 on .NET 10 and V4 on .NET Framework 4.8.
-
Export a DataGridView to Excel (.xlsx) in VB.NET — Without Office Interop
The usual Interop loop stops working on the first PC without Office, and it quietly turns a ZIP code like 02134 into 2134. This VB.NET module writes a DataGridView to a real .xlsx file instead: visible columns in screen order, numbers as numbers, dates as dates, leading zeros intact. Complete code for ReoGrid V5 on .NET 10 and V4 on .NET Framework 4.8.
-
Excel Tables in C# — What "Format as Table" Actually Saves, and How to Create One
Excel's "Format as Table" looks like formatting — a coloured header, striped rows — yet not one cell in the saved file carries a fill. What Excel stores is an object: a range, a header row and a style name. This guide opens up the table part of an .xlsx, explains what the 60 built-in styles really contain, and names the three details that decide whether Excel will open the file at all — then builds a table with filter buttons and a totals row in C# with ReoGrid V5.1.
-
Build a Receipt Generator in About 30 Lines of C# — Excel Template + ReoGrid
Design a receipt once in Excel instead of laying it out in code, then let ReoGrid load the template, fill the blanks, save a copy, and print. A complete WinForms app in about 30 lines of C#.
-
Reading, Writing, and Displaying Excel Files in VB.NET
A practical guide to working with .xlsx files in VB.NET — reading data, generating reports, and embedding a live spreadsheet viewer inside a WinForms or WPF desktop app. Everything here works without Office installed.
-
Display and Edit an Excel File in a WinForms or WPF App with C#
How to embed a working Excel viewer inside a .NET desktop app — load .xlsx, let users edit cells and formulas, save back to disk. Minimal WinForms and WPF examples in C#.
-
Export a DataTable to Excel (.xlsx) in C# Without Office Interop
How to write a DataTable out as a real .xlsx file from C# — headers, formats, multiple sheets, and the ASP.NET Core download pattern. Side-by-side examples with ClosedXML, EPPlus, and ReoGrid.
-
Reading and Writing Excel Files in C# Without Office Interop
A practical guide to handling .xlsx files from C# without installing Microsoft Office. Compares the main approaches — OpenXML SDK, ClosedXML, EPPlus, NPOI, and ReoGrid — and shows working code for the common cases.