FastExcel - GitLite

KO | EN

gitlite — search

#python #ai #go #golang #android #docker #macos #java #awesome #cli #kubernetes #pytorch #mcp #ios

FastExcel

(★ 338)

Fast Excel Reading and Writing in .Net

파일 탐색기

최종 버전 다운로드 (.zip)

- - benchmarks.yml
  - build.yml
  - release.yml
- Cell.cs
- CellRange.cs
- DefinedName.cs
- DefinedNameLoadException.cs
- DefinedNamesExtensions.cs
- ExcelColumnAttribute.cs
- FastExcel.cs
- FastExcel.csproj
- FastExcel.DefinedName.cs
- FastExcel.Read.cs
- FastExcel.Update.cs
- FastExcel.Worksheets.cs
- FastExcel.Write.cs
- Row.cs
- SharedStrings.cs
- Worksheet.cs
- WorksheetAddSettings.cs
- WorksheetProperties.cs
- ComparisonBenchmarks.cs
- FastExcel.Benchmarks.csproj
- Program.cs
- ReadBenchmarks.cs
- README.md
- WriteBenchmarks.cs
- - AllocationProbe.cs
  - CultureScope.cs
  - KnownBug.cs
  - LargeWorkbook.cs
  - PerfBaseline.cs
  - PerfMeasurement.cs
  - PerfScenario.cs
  - TempWorkspace.cs
  - XlsxBuilder.cs
- - AllocationBudgetTests.cs
  - PerfReportTests.cs
  - ThroughputTests.cs
- - OneRowFile.xlsx
  - RouteMaster.xlsx
  - SameKey.xlsx
  - special-char.xlsx
  - template.xlsx
- AssemblyInfo.cs
- CellWriteTests.cs
- ColumnNameTests.cs
- DefinedNameTests.cs
- FastExcel.Tests.csproj
- FastExcelTests.cs
- perf-baseline.json
- README.md
- RowReadTests.cs
- SharedStringsTests.cs
- StreamLifecycleTests.cs
- WorksheetResolutionTests.cs
.gitignore
FastExcel.sln
LICENSE
README.md

# 설치 가이드

1. 코드 내려받기

git clone https://github.com/ahmedwalid05/FastExcel

깃허브에서 프로젝트 코드 전체를 내 컴퓨터로 내려받습니다.

cd FastExcel

방금 내려받은 프로젝트 폴더 안으로 이동합니다.

2. .NET

보통 추천

사전 준비물

Git GitHub에서 프로젝트 코드를 내려받으려면 필요합니다.
.NET SDK dotnet 명령어를 쓰기 위한 SDK입니다.

cd FastExcel.Benchmarks

이 프로젝트의 관련 파일이 하위 폴더 안에 있어서, 먼저 그 폴더로 이동합니다.

dotnet restore

프로젝트에 필요한 패키지를 내려받습니다.

dotnet run

프로젝트를 빌드하고 바로 실행합니다.

✅ dotnet run 실행 후 터미널에 나타나는 안내 메시지나 주소를 확인하세요.

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

### Looking for maintainers. Please reach out at fastexcel(at)ahmedmassoud.me
# Fast Excel

#### Build / Release
![Build status](https://github.com/ahmedwalid05/FastExcel/workflows/Build/badge.svg)
[![License](http://img.shields.io/:license-MIT-blue.svg)](https://raw.githubusercontent.com/ahmedwalid05/FastExcel/master/LICENSE)
[![NuGet Badge](https://buildstats.info/nuget/FastExcel)](https://www.nuget.org/packages/FastExcel/)

#### About
- Provides a fast way of reading and writing to *.xlsx Excel files.
- Small memory footprint while running
- Does not use the Open XML SDK to interact with the data but going directly and editing the underlying xml files.
- This project is not intended to be a replacement for full featured Excel packages with things like formatting, just light weight fast way of interacting with data in Excel.

#### Version 3
- Contribute using Visual Studio 2017
- Built using [.NetStandard](https://docs.microsoft.com/en-us/dotnet/standard/library) 2 targeting:
	- .Net Core 2.0
	- .Net Framework 4.6.1

#### Installation
```
PM> Install-Package FastExcel
```

## Write Demo 1
This demo uses Generic objects, ie any object you wish with public properties
```C#
// Get your template and output file paths
var templateFile = new FileInfo("C:\\Temp\\Template.xlsx");
var outputFile = new FileInfo("C:\\Temp\\output.xlsx");

using (FastExcel.FastExcel fastExcel = new FastExcel.FastExcel(templateFile, outputFile))
{
    List<MyObject> objectList = new List<MyObject>();

for (int rowNumber = 1; rowNumber < 100000; rowNumber++)
    {
        MyObject genericObject = new MyObject();
        genericObject.StringColumn1 = "A string " + rowNumber.ToString();
        genericObject.IntegerColumn2 = 45678854;
        genericObject.DoubleColumn3 = 87.01d;
        genericObject.ObjectColumn4 = DateTime.Now.ToLongTimeString();

objectList.Add(genericObject);
    }
    fastExcel.Write(objectList, "sheet3", true);
}
public class MyObject
{
    public string StringColumn1 { get; set; }
    public int IntegerColumn2 { get; set; }
    public double DoubleColumn3 { get; set; }
    public string ObjectColumn4 { get; set; }
}
```

## Write Demo 2
This demo lets you specify exactly which cell you are writing to

```C#
// Get your template and output file paths
var templateFile = new FileInfo("C:\\Temp\\Template.xlsx");
var outputFile = new FileInfo("C:\\Temp\\output.xlsx");

//Create a worksheet with some rows
var worksheet = new Worksheet();
var rows = new List<Row>();
for (int rowNumber = 1; rowNumber < 100000; rowNumber++)
{
    List<Cell> cells = new List<Cell>();
    for (int columnNumber = 1; columnNumber < 13; columnNumber++)
    {
        cells.Add(new Cell(columnNumber, columnNumber * DateTime.Now.Millisecond));
    }
    cells.Add(new Cell(13, "Hello" + rowNumber));
    cells.Add(new Cell(14, "Some Text"));
 
    rows.Add(new Row(rowNumber, cells));
}
worksheet.Rows = rows;

// Create an instance of FastExcel
using (FastExcel.FastExcel fastExcel = new FastExcel.FastExcel(templateFile, outputFile))
{
    // Write the data
    fastExcel.Write(worksheet, "sheet1");
}
```

## Read Demo 1 Get Worksheet

```C#
// Get the input file path
var inputFile = new FileInfo("C:\\Temp\\input.xlsx");

//Create a worksheet
Worksheet worksheet = null;

// Create an instance of Fast Excel
using (FastExcel.FastExcel fastExcel = new FastExcel.FastExcel(inputFile, true))
{
    // Read the rows using worksheet name
    worksheet = fastExcel.Read("sheet1");

// Read the rows using the worksheet index
    // Worksheet indexes are start at 1 not 0
    // This method is slightly faster to find the underlying file (so slight you probably wouldn't notice)
    worksheet = fastExcel.Read(1);
}
```

## Read Demo 2 Get All Worksheets

```C#
// Get the input file path
var inputFile = new FileInfo("C:\\Temp\\fileToRead.xlsx");

// Create an instance of Fast Excel
using (FastExcel.FastExcel fastExcel = new FastExcel.FastExcel(inputFile, true))
{
    foreach (var worksheet in fastExcel.Worksheets)
    {
        Console.WriteLine(string.Format("Worksheet Name:{0}, Index:{1}", worksheet.Name, worksheet.Index));
        
        //To read the rows call read
        worksheet.Read();
        var rows = worksheet.Rows.ToArray();
        //Do something with rows
        Console.WriteLine(string.Format("Worksheet Rows:{0}", rows.Count()));
    }
}
```

## Update Demo

```C#
// Get the input file path
var inputFile = new FileInfo("C:\\Temp\\input.xlsx");

//Create a some rows in a worksheet
var worksheet = new Worksheet();
var rows = new List<Row>();

for (int rowNumber = 1; rowNumber < 100000; rowNumber += 50)
{
    List<Cell> cells = new List<Cell>();
    for (int columnNumber = 1; columnNumber < 13; columnNumber+= 2)
    {
        cells.Add(new Cell(columnNumber, rowNumber));
    }
    cells.Add(new Cell(13, "Updated Row"));

rows.Add(new Row(rowNumber, cells));
}
worksheet.Rows = rows;

// Create an instance of Fast Excel
using (FastExcel.FastExcel fastExcel = new FastExcel.FastExcel(inputFile))
{
    // Read the data
    fastExcel.Update(worksheet, "sheet1");
}
```

### Thanks to
- Sibz
- paritoshmmmec

- Insperation for this project came from [SejExcelExport](https://github.com/jsegarra1971/SejExcelExport) by jsegarra1971 who did a great job. I wanted to have my own crack at this problem.
- mrjono1 The creater of this library