🔥 Need to get some EXCEL work done? Why not let your code work FOR YOU? It's easier than you think! Make an Excel Editor with C#! Easily Create, Write, and Read Excel files with C# and .NET! 🐝 Thank you, LibXL, for sponsoring this video! Need it to be even easier than what we have shown you here? Well, with the LibXL library its as easy as it gets! Download LibXL NOW and start building professional excel applications TODAY! www.libxl.com/?EU 🚀 Master C# and .NET programming EASILY with our best-selling C# Masterclass: bit.ly/47Hk3u7
Great entry intro into the topic. Thanks! Although must say after short exercise that editing excel files via OpenXML library is not the most straightforward way to make it :)
Hi, you say that it works perfectly, however if you look at the data. 30 is inserted as a string but translated in excel as a number. So it is not perfectly and numbers need some work
Excel had always been tricky with converting data types into funny strings/ digits or whatever... (as we all know). What helped in my case was to programmaticaly set data type for specific column before putting data into this column. The key is "before".
AddWorkbookPart(); the "doc" is not reconized ... Severity Code Description Project File Line Suppression State Error (active) CS0103 The name 'doc' does not exist in the current context ConsoleAppWithExcel D:\CSharpProjects\ConsoleAppWithExcel\Program.cs 22 using System; using System.Reflection; using DocumentFormat.OpenXml; using DocumentFormat.OpenXml.Packaging; using DocumentFormat.OpenXml.Spreadsheet; namespace ConsoleAppWithExcel { class Program { static void Main(string[] args) { Console.WriteLine("Give me ur filename ");
🔥 Need to get some EXCEL work done? Why not let your code work FOR YOU? It's easier than you think! Make an Excel Editor with C#! Easily Create, Write, and Read Excel files with C# and .NET!
🐝 Thank you, LibXL, for sponsoring this video! Need it to be even easier than what we have shown you here? Well, with the LibXL library its as easy as it gets! Download LibXL NOW and start building professional excel applications TODAY! www.libxl.com/?EU
🚀 Master C# and .NET programming EASILY with our best-selling C# Masterclass: bit.ly/47Hk3u7
I've tried to make this work the whole morning before finding your video, you saved me! thank you very much...
thank you so much ... I understood everything
was useful for me. thanks
Great entry intro into the topic. Thanks! Although must say after short exercise that editing excel files via OpenXML library is not the most straightforward way to make it :)
Thanks for sharing such nice contents! Very much appreciated! Where can i find the WPF tutorial for the Student Diary App?
Jannick is about to recorded it. It should be live next Week
Hello
Good afternoon,i am Beth happy.thank you very much.
Fernando pena.💪👏🆗
How to create excel file from list of dto on browser by blazor web assembly and finally save it on user machine?
I have a question
How do I change the default save location to not save in the Debug folder?
Have it as a memory stream and you can save anywhere.
Hi, you say that it works perfectly, however if you look at the data. 30 is inserted as a string but translated in excel as a number. So it is not perfectly and numbers need some work
Excel had always been tricky with converting data types into funny strings/ digits or whatever... (as we all know). What helped in my case was to programmaticaly set data type for specific column before putting data into this column. The key is "before".
Price is crazy
AddWorkbookPart(); the "doc" is not reconized ...
Severity Code Description Project File Line Suppression State
Error (active) CS0103 The name 'doc' does not exist in the current context ConsoleAppWithExcel D:\CSharpProjects\ConsoleAppWithExcel\Program.cs 22
using System;
using System.Reflection;
using DocumentFormat.OpenXml;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;
namespace ConsoleAppWithExcel
{
class Program
{
static void Main(string[] args)
{
Console.WriteLine("Give me ur filename ");
String filePath = Console.ReadLine();
//D:\a.xls
using (SpreadsheetDocument doc = SpreadsheetDocument.Create(filePath, SpreadsheetDocumentType.Workbook));
{
WorkbookPart workbookPart = doc.AddWorkbookPart();
workbookPart.Workbook = new Workbook();
}
}
}
}