Hey there I had followed your steps to read an excel file using C# WinForms. When I run my code it shows a error message at " using IExcelDataReader reader = ExcelReaderFactory.CreateReader(stream)" this line? Why is it so? Can you help?
Great tutorial! I'm wanting to take the data stored in specific rows and use with another button, how would I be able to use the data from cboSheet in a button? I'm guessing I need an array to store the row data?
iv a two pbs 1. that when i click or select the sheet again so it reads the excel again and that wht idn want have 2. when the sheet is empty so ive to show a messagebx that the Sheet empty si how i can check if the Sheet empty or not thank you so much :)
Hi! Thanks for the great tutorial! I have a problem in writing line 33 : File is not recognized by VS2019...I have installed both ExcelDataReader, ExcelDataReader.DataSet. Thanks for the help!
System.NullReferenceException: 'Object reference not set to an instance of an object.' System.Windows.Forms.ComboBox.SelectedItem.get returned null. this error is comming on line no. 24
Hi !! your toturial is Awesome .... i tried to implement it in my side but it gives this error : System.IO.IOException: 'The process cannot access the file 'G:\Book1.xlsx' because it is being used by another process.' I tried to make it two separate processes (Read file path button --> then Get Sheet Content) but also same message always show.
@@foxlearn i see my bad sorry , do you have any tutorial to write excel file from C# windows form? i need to write and update excel file from winform apps thankyou
This code doesnt work for me I get The name 'InitializeComponent' does not exist in the current context The name 'InitializeComponent' does not exist in the current context
Thank you guys, this is the best channel every for programmers, always brings the new.. Thanks a million.
Thank you so much !
Can we use google sheet as a data base for .net c# ? I need your help
Hello, I have one Question bellow:
How do we create link in DGV to other Form in visual studio 2022?
Hey there I had followed your steps to read an excel file using C# WinForms.
When I run my code it shows a error message at " using IExcelDataReader reader = ExcelReaderFactory.CreateReader(stream)" this line? Why is it so? Can you help?
Is it possible on this program to remove the grid lines when I import the excel file?
Yes, you can do that
@@foxlearn how to include that into the program? I'm still learning C# and I have no idea on how to do it
how could I do this same process but to export from GridView to Excel using some library?
You can do the same video th-cam.com/video/4wYIxi_8sDg/w-d-xo.html
Great tutorial!
I'm wanting to take the data stored in specific rows and use with another button, how would I be able to use the data from cboSheet in a button? I'm guessing I need an array to store the row data?
You can view this video th-cam.com/video/FhYCUhaDEt4/w-d-xo.html .Thank you !
@@foxlearn Thanks, you're a huge help!
hi, Thanks for the guide.
I have problem with the line:
"DataSet result = reader.AsDataSet..."
You should install IExcelDataReader.DataSet
@@foxlearn I have installed, but the same problem persist.
Thank you so much for the guide!
iv a two pbs
1. that when i click or select the sheet again so it reads the excel again and that wht idn want have
2. when the sheet is empty so ive to show a messagebx that the Sheet empty si how i can check if the Sheet empty or not thank you so much :)
How to load Data From Notepad (.CSV) to DataGridView in C# Windows Form Application ?
It worked great thanks
Good tutorial
Hi! Thanks for the great tutorial!
I have a problem in writing line 33 : File is not recognized by VS2019...I have installed both ExcelDataReader, ExcelDataReader.DataSet.
Thanks for the help!
thank you, it's a great tutorial, easy to understand
Hi I follow up your programs, in this I have an error in "UseHeaderRow = true". How to Correct it, Plz advice. Thanks.
What error are you getting?
Is it possible to add rows to that excel file ?
Best Tutorial
Thank you !
Hey! How can I search through the excel from the application you created?
System.NullReferenceException: 'Object reference not set to an instance of an object.'
System.Windows.Forms.ComboBox.SelectedItem.get returned null.
this error is comming on line no. 24
Thank you so much for this guide!!
Thank you !
Hi !! your toturial is Awesome .... i tried to implement it in my side but it gives this error :
System.IO.IOException: 'The process cannot access the file 'G:\Book1.xlsx' because it is being used by another process.'
I tried to make it two separate processes (Read file path button --> then Get Sheet Content) but also same message always show.
Great! Works perfect!
how to convert txt file to xls file using c#?
Hello i have problem with txtFilename , i cant find it anywhere , after i update and install all exceldatareader , please help
txtFileName is name of your textbox control
@@foxlearn i see my bad sorry , do you have any tutorial to write excel file from C# windows form? i need to write and update excel file from winform apps thankyou
thank you very much for the tutorial :)
Thank you !
Error CS0104 'DataTable' is an ambiguous reference between 'System.Data.DataTable' and 'Microsoft.Office.Interop.Excel.DataTable'
ty
"tableCollection" doesn't works in my program, getting error message!!!!
I'm getting the same error, did you ever figure it out?
On form load must be defined
@@netforcetechnologiesllc DataTableCollection tableCollection; on event Form load
i have a problem with txtfilename.Text -eror , and )};
Is it all free ?
Thanks for sharing..
This code doesnt work for me I get The name 'InitializeComponent' does not exist in the current context
The name 'InitializeComponent' does not exist in the current context
Please check your code again. i think you miss something
can i get the code for this
datagridview doesn-t contain a definition for 'items'
Items of Combobox
Are you able to write to excel files?
Yes, you can write data to excel file
nice
Thank you !
GOOD.
Thank you !
bro its work but website is down do something
hi bro can i have this app source code but i have very emergency need to this :(
You can find code at my website. thank you !
heey this dapper-plus is trial program trial version is over
Error DataTable
Ato Fast Kaj KOrla kivabe sikba ?
Not clear your intention
All I have is CreateBinaryReader and not CreateReader
PS your end screens are always in the way.. That's annoying.
Thank you for your suggestion !
could you please provide the source code of this program, also is it fine to use it in my projects?
You can find source at my site. thank you !
@@foxlearn Thank you
@@foxlearn can not be found would you please add the link