Read Excel File in VS Code using c#?

damn daniel

If someone could help me by providing me with a step by step process of reading an Excel file using the programming language c# on VS Code(NOT visual studio IDE) It will be really helpful to me and others as this is a totally new working environment for me. Thanks.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

li na7y ago
Hi,

I had an experience. Firstly, creat a VS code project and open the xxx.csproj file to add the folllowing code.

Secondly, input "dotnet build" command at the terminal window of Visual Studio Code.
It will install the Spire.Xls package. And then you can add the folllowing code in Program.cs to load, read the Excel file and do other operations on it. Hope this could help you.

Workbook workbook = new Workbook();
workbook.LoadFromFile("sample.xlsx");

I refered to the tutorial (https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Create-Excel-File-in-C-VB.NET.html)
Maen Badwan7y ago
You mentioned that you want to read Excel files using VS code (.NET core), but it's not clear what exactly you want to do after reading the file?
Do you want to convert it to a different format (such as DOCX, PDF, Text, etc.)?
Do you want to view it?

If you want to convert the Excel file under.NET core, you can try using DocumentConverter class from LEADTOOLS that can convert your Excel files into other document formats (such as DOCX, PDF, Text, RTF, etc.)
The following code shows how you can convert any supported document format (such as Excel) into Text format using the DocumentConverter class:
// The following function receives the URI of your Excel file and converts it into Text format
// When calling it, just pass the URI of your Excel file
public async Task ConvertDoc(Uri uri)
{
if (uri == null)
throw new ArgumentNullException(nameof(uri));


using (DocumentConverter documentConverter = new DocumentConverter())
{
var options = new LoadDocumentOptions();
var document = DocumentFactory.LoadFromUri(uri, options);

var outFile = @"output.txt";
var format = DocumentFormat.Text;

var jobData = DocumentConverterJobs.CreateJobData(document, outFile, format);
jobData.JobName = "conversion job";
var job = documentConverter.Jobs.CreateJob(jobData);
documentConverter.Jobs.RunJob(job);

if (job.Status == DocumentConverterJobStatus.Success)
{
Console.WriteLine("Success");
MemoryStream ms = new MemoryStream();
byte[] filebytes = System.IO.File.ReadAllBytes(outFile);
ms.Write(filebytes, 0, filebytes.Length);
ms.Seek(0, SeekOrigin.Begin);
return File(ms, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "result.xls");
}
else
{
Console.WriteLine("{0} Errors", job.Status);
foreach (var error in job.Errors)
{
Console.WriteLine("  {0} at {1}: {2}", error.Operation, error.InputDocumentPageNumber, error.Error.Message);
}
return  NotFound();
}
}
}
More details can be found here:
https://www.leadtools.com/help/leadtools/v20/dh/doxc/documentconverter.html
Sanwar Ranwa7y ago
Hello Damn

Vs code is useful for designing.VS Code only supports a limited set of project types (primarily .NET Core). For full .NET project support, we suggest you use Visual Studio Community.

You can check this Links

https://code.visualstudio.com/docs/languages/csharp

You can write your function in Visua studio and then consume it using any js framework in vs code with your design