Reading data from Excel (.xls) files in ASP.NET (2023)

comments postedPratush MittalTuesday, April 8, 2008 at 10:41 pm

Can you tell me how to do this if I don't want to corrupt the data file (Sample1.xls in this case) and accept user input?

comments postedsamWed April 9, 2008 at 5:51 am

Hi can you tell me why i am getting error message while running oleda.Fill(ds, "Employees") exception as below
The Microsoft Office Access database engine could not find the object 'Sheet1$'. Make sure the object exists and you spelled its name and pathname correctly.

thanks for your help!

comments postedSuprotim AgarwalThursday, April 10, 2008 at 12:59 am

Pratyush - You can create connection strings at runtime.
Sam: I'll look into this bug.

Thanks. super protein

comments postedFSaturday, April 19, 2008 at 6:20

Ah ah ah ah ah

comments postedFSat April 19, 2008 6:21 am

ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff

comments postedWayneMonday, April 21, 2008 at 9:55 am

Does this solution require Excel to be installed on the system running this .Net application? I get an error similar to Sam's, but I don't have Excel installed.

Also, does this solution require the spreadsheet to only store *values* or can it read *formulas*?

comments postedRagasudaWednesday, April 23, 2008 at 2:12 pm

This is the exception I get: "The Microsoft Jet database engine cannot find the object 'test'. Please ensure that the object exists and that you have spelled its name and pathname correctly" The name of my excel sheet is test where I Shouldn't it? I specified the path and what is the purpose of this sample .xls data source?

comments postedheheWednesday, April 30, 2008 at 5:48 pm

i have this error
Error1Expected statement. "System.Data.OleDb;"
Error 2 The type 'OleDbConnection' is undefined.
Error3Type 'OleDbCommand' is undefined.
Error4Type 'OleDbDataAdapter' is undefined.
Error5Type 'dataset' is undefined.
How can I fix them?
thank you so much

comments postedheheThursday, May 1, 2008 at 9:45 am

i solved my problem
But in the browser there is no result
What do you think the problem is?

comments postedSuprotim AgarwalSat May 3, 2008 at 7:16 am

Make sure the asp.net user has appropriate permissions to access and read the file.

comments postedanythingWednesday, May 7, 2008 at 2:46 pm

How to insert dataset into database?

comments posteddeveloperTuesday, May 13, 2008 at 8:03 pm

Hello, I have the following error:

"No installable ISAM found."
Can someone please help!

Thanks in advance!

comments posteddeveloperWed May 14, 2008 at 2:20 pm

Hello everyone. I finally got my app working. I had a similar problem to Sam. However, I noticed that the .xls file does not have sheet1, sheet2 or sheet3 at the bottom of the page. So I'm assuming the object doesn't recognize "Sheet1$" when debugging. On the other hand, the .xlsx file has sheet1, sheet2 and sheet3 at the bottom. So when I run the program it works.
Thanks Suprotim Agarwal! Keep up the good work.

comments postedsalmanMonday, May 26, 2008 at 1:44 am

All of this works, but the data is not displayed in the grid
oleda.Fill(ds,"employees"); there is nothing in ds
means that ds returns null

Can anyone help me with this problem..?

comments postedpaving stonesMonday, June 9, 2008 at 9:39 am

The whole problem is in the connection string. example:
Redeploy ConfigurationManager.ConnectionStrings["xls"].ConnectionString
exist
Dim sConnectionString As String = "Proveedor=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=" & Server.MapPath("Sample1.xls") _
& ";" & "Extended property=Excel 8.0;"
everything will work out
MapPath gets the full path.
If nothing is populated, make a label and add "Catch ex as exception" label1.Text = ex.Message...

comments postedSuprotim AgarwalTuesday, June 17, 2008 at 1:13 pm

Developer, Pavel: Thanks for the suggestion. Interestingly, I was able to run the code with the configuration settings posted. Anyway, thanks for sharing your solution for those who couldn't get it to work.

comments postedMarcusTuesday, June 24, 2008 at 5:29 am

Thank you for your article. I know you can also write to excel files using OLE DB drivers. Do you know how can I write formulas in excel file using OLE DB? Thanks.

comments postedjawThursday, July 10, 2008 at 9:58 am

Hello! ! can you help me? I want to read data from multiple Excel workbooks and populate it into one dataset. I know it can be done using getfiles but not sure what to do with it. (vb.net)

comments postedmohammad javedTuesday, July 15, 2008 at 1:13 am

very nice code. Very useful code for everyone.

comments postedmohammad javedTuesday, July 15, 2008 at 1:31 am

Thank you for your article. I know you can also write to excel files using OLE DB drivers. Do you know how can I write formulas in excel file using OLE DB? Thanks. I am able to run the code with the configuration settings posted. Anyway, thank you for those who share your solution
They can't enforce it.
very nice code. Very useful code for everyone.

comments postedBadalcant VermaTuesday, July 15, 2008 at 1:32 am

very nice code. Very useful code for everyone.

comments postedSuprotim AgarwalWednesday, July 16, 2008 at 2:06 pm

Mohammad: I haven't really tried writing formulas yet. However, I suggest you post this question here for better answers.

http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.programming⟨=en&cr=US

comments postedArdaTuesday, July 22, 2008 at 3:06 am

How to read excel into a datagrid that already has headers? When I insert a textbox in column dg, the excel file cannot be opened.
and? Who can solve it?

comments postedhe sits downThursday, July 24, 2008 at 12:26 am

I have an excel sheet with one column having decimal values ​​(4.5678764) when i use Microsoft.Jet.OLEDB.4.0;DataSource=file.xls;Extended Properties=Excel 8.0 as connection string it populates my dataset . But the dataset only contains the value (4.5678) (ie) only 4 digits. Please help me to get all numbers in excel sheet. Thanks

comments postedtechnology strategyFriday, March 27, 2009 at 6:10 am

Hi guys,
Everyone who has problems with Excel...
Let me tell you, anyone trying to load an Excel sheet with AutoFilter, what usually happens if we AutoFilter Excel and then create a dummy sheet to filter on, so this interferes with our ASP.Net code. Remove the filter and try to use it. healthy

comments posteddeafMonday, April 13, 2009 at 3:10 am

// Edited in original post.
//Specify EDIT in the EDIT area

protected void Page_Load(object sender, EventArgs e)
{
String connString = ConfigurationManager.ConnectionStrings["xls"].ConnectionString;
// create connection object
OleDbConnection oledbConn = new OleDbConnection(connString);
attempt
{
// open the connection
oledbConn.Open();
#region"edit"
DataTable dtSheetName = oledbConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
如果(dtSheetName == nulo || dtSheetName.Rows.Count==0)
{
if (oledbConn.State == ConnectionState.Open)
oledbConn.close();
throw new Exception("Could not find the sheet in the selected file.");
}
// Create an OleDbCommand object and select data from Sheet1
OleDbCommand cmd = new OleDbCommand("SELECT * FROM ["+dtSheetName.Rows[0]["TABLE_NAME"].ToString()+"]", oledbConn);
#endregion
// create new OleDbDataAdapter
OleDbDataAdapter oleda = new OleDbDataAdapter();

oleda.SelectCommand = cmd;

// Create a dataset containing the data extracted from the worksheet.
Dataset ds = new Dataset();

// Populate the dataset with data extracted from the worksheet.
oleda.Fill(ds, "staff");

// bind data to GridView
GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataBind();
}
catch
{
}
at last
{
// close the connection
oledbConn.close();
}

}

comments postedjessicaThursday, April 16, 2009 at 9:09 am

Unfortunately it doesn't work. Nothing is displayed on the page!

comments postedAkshayThursday, April 16, 2009 at 3:17 pm

I also got the same error with SAM. I copied the dll to debug and release the folder, then it worked.

I'm not sure why. But surely there are access security codes...

Thanks
Akshay

comments postedSuprotim AgarwalFriday, April 17, 2009 at 5:54 am

Thank you Akshay.

@Everyone - This sampler works fine in most cases. For special cases where AutoFilter or code is problematic, read tips from TechTactics, Dheeraf, or Akshay. Thanks for the tip!

comments postedallenFriday, April 24, 2009 at 7:11 am

This is a good solution to my problem, although I'm having issues. I have a column in my Excel spreadsheet filled mostly with numbers, but in rare cases it might be a string. When you run the code shown here, the string values ​​read from the dataset are of type DBNull , while all numbers are of type Double . Is there a way to ensure all data in that column is read as a string?

comments posteda different allenThursday, April 30, 2009 at 10:10 pm

@Alan: Oh yes, harmful type settings in Excel. By default, the Jet driver only displays the first 8 lines of the file to determine the type. Therefore, modify the registry keys HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Excel and
Change "TypeGuessRows" to 0. This will cause it to look at all rows before setting the type.

Also, I just want to point out that Jet is deprecated and not available in native 64-bit mode.

comments postedcrisisThursday, June 4, 2009 at 4:03 pm

I got the error from Sam. I'm assuming the sampler will run and copy the code into the existing application. I have a file called "Wintel_May09_VIAR.xslt". I'm setting the connection string on the fly (I have an upload process before trying to open the file). My "sheet" has the same name as the file minus the .xslt . The spreadsheet has several columns, one of which is called "Address". The error is: The Microsoft Office Access database engine could not find the object 'address'. Looking at the package contents, my tables folder contains a set of tables. table1 has a tableColumn with a unique name of "Address". what do i need to change?

comments postedoakThursday, June 4, 2009 at 4:21 pm

Someone should point out that the "$" appended to the sheet name is required. I added "$" and everything works fine.

comments postedwest hamSaturday, June 6, 2009 at 6:59 am

use this:
string connString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + filename + @"; Extended Properties=""Excel 8.0;IMEX=1;HDR=YES""";

then it will work

www.helheten.net

comments postedkhalilSunday, June 7, 2009 at 3:50 pm

Now works after creating the connection string in code, no need to read it from Web.Config

string connString = "Vendor=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + Server.MapPath("Excel2007.xlsx") + ";" + "Extended Properties=Excel 12.0;";

Thanks

comments postedWahab HusseinTuesday, June 9, 2009 at 2:08 pm

You can also check out this article. Here you can read data from Excel and write data to Excel.
http://www.codeproject.com/KB/vb/ExcelDataManipulation.aspx

comments postedSuprotim AgarwalWed Jun 10, 2009 3:56 am

Thanks to oaksong, Westham, Khalil for providing solutions for those whose code didn't work.

Wahab: Thanks for the link.

comments postedFilipinoTuesday, July 14, 2009 at 7:30 am

Hello,

Nice article, but oledb connection is a slow way to deal with excel files. You can try some 3rd party components like GemBox.Spreadsheet - .NET component for Excel, free for commercial use (limited to 150 rows).

http://www.gemboxsoftware.com/GBSpreadsheet.htm

Felipe

comments postedgentlemenFriday, September 25, 2009 at 9:13 am

I'm trying to read an Excel 2003 worksheet. When I try to open the connection I get the following error:
"The Microsoft Jet database engine cannot open the file ''. It is opened exclusively by another user, or you need permission to view its data."

The connection string I am using is "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties='Excel 8.0;HDR=YES;';Data Source=CI.xls".

I don't know where I am going wrong.

Thanks in advance,
gentlemen

comments postedIkeWed Oct 21, 2009 11:48 am

This code works perfectly as expected. And thanks for the code. However, I made the following changes... so that it reads more excel files...

1)
Added web.config {0}

2)
Create a folder called excel in VS project/solution and put all .xls files under it to use the following code

string connString = string.Format(ConfigurationManager.ConnectionStrings["xls"].ConnectionString, Server.MapPath(@"\excel\mysample.xls")) ;
// create connection object
OleDbConnection oledbConn = new OleDbConnection(connString);
attempt
{
// open the connection
oledbConn.Open();
string sql = "SELECT * FROM [Sheet1$]";

........................
......................

Thanks again..

comments postedAnsomanoTuesday, October 27, 2009 at 7:20 am

Hello everyone,

I have generated an xml spreadsheet (*.xls) using XSL. I have another program that reads this spreadsheet and does something with it.

Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filnavn + ";" + "Extended Properties=Excel 8.0;"

Dim objCon 作为 OleDbConnection = Nueva OleDbConnection(sConnectionString)

objCon.Open() // here I get exception: External table is not in expected format

Dim objCmdSelect As OleDbCommand = New OleDbCommand("SELECT * FROM [General$]", objCon)

Dim objAdapter como OleDbDataAdapter = Nuevo OleDbDataAdapter()

objAdapater.SelectCommand = objCmdSelect

dim _DSGen as dataset = new dataset()

objAdaptador.Fill(_DSGen)

I'm having trouble opening a connection to the generated spreadsheet. It says "{" The external table is not in the expected format. "}".

my connection string is

Dim "Provider=Microsoft.Jet.OLEDB.4.0;" + "DataSource=" + filnavn + ";" + "Extended Properties=Excel 8.0;"

Do i need to change something in this string? I tried using a dataset and calling dataSet.ReadXml(excelFileName); but the dataset doesn't contain my table. Any info on how to read an xml spreadsheet?

1. How to read XML spreadsheet in OleDb? How to convert an XML spreadsheet to a Microsoft Office Excel worksheet?

2. How to import "XML Spreadsheet" data into DataTable? Is there any other method available?

thank you so much

comments postedweave itWed Dec 2, 2009 at 1:44 am

Hi, is it possible to read the first sheet regardless of the sheet name?

comments postedEmanueleSat Dec 5, 2009 at 3:09 am

I'm new to asp.net and I'm trying to understand your code but using my own excel file I don't get any data...
I've tried adding a label after GridView1.DataBind() and filling in the "full" text, but got no response...

I'm looking to download the code to see if I'm wrong, but I can't find anything...

can you help me? ? ?

Thanks
Emanuele

comments postedMadan Chiu HanThursday, January 21, 2010 at 2:40 pm

Hello everyone
Basically the problem is in the excel file path, my code is working fine
string connString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Server.MapPath("Authors.xls") + ";" + "Extended Properties=Excel 8.0;";

OleDbConnection oledbconn = new OleDbConnection(connString);
attempt
{
oledbconn.Open();
OleDbCommand cmd = new OleDbCommand("Seleccione * de [Hoja1$]", oledbconn);
OleDbDataAdapter oleda = new OleDbDataAdapter();
oleda.SelectCommand = cmd;
Dataset ds = new Dataset();
oleda.Fill(ds, "Author");
GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataBind();
}
captura(OleDbException 前)
{
lblMessage.Text = ex.Message;
}
at last
{
oledbconn.close();
}

comments postedAyapadasFriday, February 5, 2010 at 6:12 pm

how to use where condition.plz help

comments postedRonFriday, February 19, 2010 at 4:26 am

Yes, this works. Make sure the path is correct.

Dim sConnectionString As String = "Proveedor=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=" & Server.MapPath("Sample1.xls") _
& ";" & "Extended property=Excel 8.0;"

comments postedRameshWednesday, April 14, 2010 at 8:53 am

How to compare two excel sheets and insert records into sql using c# coding (Asp.net)

comments postedXenonWednesday, April 28, 2010 at 3:12 pm

Well, this approach works perfectly...but I wonder if it is possible to use the data from the excel file and store it in an Oracle table (instead of SqlServer) with the same field names as the excel file.... ..

comments postedasTuesday, June 29, 2010 at 4:42 am

ASD

comments postedAht HusseinTuesday, June 29, 2010 at 8:10 am

nice and easy to understand..thanks a lot..doodho nahao pooto bhalo beta..

comments postedAht HusseinWednesday, June 30, 2010 at 1:28 am

nice and easy to understand..thanks a lot..doodho nahao pooto bhalo beta..

comments postedPedroWednesday, July 7, 2010 at 11:37 pm

good article! I use one of the best tools to create excel spreadsheets in C#, it can read and write excel 97~2010 from C#, it's very easy to use, I've used it a lot of time, it's good.
http://www.e-iceblue.com/Introduce/excel-for-net-introduce.html

comments postedPuneet AgrahariThursday, September 9, 2010 at 4:04 pm

Hi can you tell me why i am getting error message while running oleda.Fill(ds, "Employees") exception as below
The Microsoft Office Access database engine could not find the object 'Sheet1$'. Make sure the object exists and you spelled its name and pathname correctly.

comments postedSuprotim AgarwalFriday, September 10, 2010 at 5:40 am

Punit: The error could be caused by a path or permission issue, but I'm not sure. Make sure the ASP.NET runtime has permission to access this file.

comments postedVamsi KrishnaMonday, September 20, 2010 at 7:17 am

Hi can you tell me why i am getting error message while running oleda.Fill(ds, "Employees") exception as below
The Microsoft Office Access database engine could not find the object 'Sheet1$'. Make sure the object exists and you spelled its name and pathname correctly. What is this "employee"?
please

comments postedgreaseThursday, September 30, 2010 at 4:08 am

Astonishing. Your website is fantastic. keep it up

comments posteda BCFriday, October 1, 2010 at 4:59 pm

what is abc

comments postedJose Marie AmparoTuesday, October 5, 2010 at 11:32 pm

please help.
I am new to programming. I need a code to manipulate columns and rows in excel (eg sort columns, delete columns, arrange columns) and display it on a web page.

Thanks in advance and more strength.

comments postedon his mohitesMonday, October 25, 2010 at 2:06 pm

i solved my problem
But in the browser there is no result
What do you think the problem is?
My excel file is called book2.xls

comments postedBas GoodmansFriday, November 26, 2010 at 2:29 pm

@wamsey
See the version published by Deeraf.
You need the exact name of the sheet you want to read. If your code can't find the "Sheet1$" object, you (or your user) may have renamed the sheet or are using a different language version of Excel.
The code provided by Deeraf solves this problem by getting the sheet by index rather than by name.

@Suprotim: Great article.

comments postedinternal organsMonday, November 29, 2010 at 3:45 am

I'm a non-techie! I have an application available in the public domain. Has functionality where people can download a sample excel file, insert their own data, and upload it back to the app: the app reads the data, validates it, and inserts the data into dB. Since the website/app is in the public domain, it is possible for someone to write malicious macros and upload files. Is there a way to check if the file being uploaded has macros (without opening it) and remove them if they do?

comments postedmiguelFriday, December 10, 2010 at 1:51 am

Lecturer EXCEL .NET
~~~~~~~~~~~~~~~~~

The EXCEL READER .NET component is very useful for this.
(www.devtriogroup.com)

comments postedrhinoTuesday, December 14, 2010 at 3:01 am

This solution works well if the Excel upload is a "normal" Excel file without formulas or locks.
But when I try to upload a .xls file that contains an exported xml spreadsheet from my website, I have a problem.
The reason I'm using xml export is because other methods using htmlwriter & reportviewer or asp.net excel libraries don't generate excel files with formulas and protection respectively or don't allow batch downloads.

This code works but it gives me the message "The external table is not in the expected format" when I try to load the opened excel file. I get an error when I try to upload with the excel file closed.

Does anyone have a solution for this?

comments postedDavid MorleyMonday, December 20, 2010 at 2:30 pm

I can't use any connection string. They all say no installable ISAM can be found. I'm trying to get strings from web.config and trying to write strings directly like this:

dim root as a string
root = HttpContext.Current.Server.MapPath("BoxStore")
Dim file path as string = root & "\" & "Box_zero.xls"
'Dim conxString As String = "Provider=Microsoft.jet.OLEDB.4.0;Data Source=filepath;ExtendedProperties=""Excel 8.0;HDR=No;"""' 版本 A
'Dim conxString As String = "Provider=Microsoft.jet.OLEDB.4.0;Data Source=filepath;ExtendedProperties=""Excel 9.0;HDR=No;"""' 版本 B
'Dim conxString As String = "Provider=Microsoft.jet.OLEDB.4.0;Data Source=filepath;ExtendedProperties=""Excel 10.0;HDR=No;"""' C 版
'Dim conxString As String = "OLEDB;Provider=Microsoft.jet.OLEDB.4.0;Data Source=filepath;ExtendedProperties=""Excel 8.0;HDR=No;"""'版本 D
'Dim conxString As String = "Provider=Microsoft.jet.OLEDB.4.0;Data Source=d:\websites\3bbb3.com\wwwroot\BoxStore\Box_zero.xls;ExtendedProperties=""Excel 8.0;HDR=No;"" “'版本 E
Dim conxString As String = "Provider=Microsoft.jet.OLEDB.4.0;Data Source= & filepath &;ExtendedProperties=""Excel 8.0;HDR=No;"""' 版本 F

I'm using VS 2008 SP1. Excel 97-2003, located in the \Boxstore folder. I'm running out of ideas! Any hints would be greatly appreciated.

comments postedAshMonday, December 20, 2010 at 11:42 pm

Check if the following items are of the same type

http://aspdotnetmatters.blogspot.com/2010/12/get-excel-sheet-names-in-aspnet.html

http://aspdotnetmatters.blogspot.com/2010/12/reading-excel-file-in-aspnet.html

comments postedHamidTuesday, December 21, 2010 at 7:17 am

Can we import excel files through SqlConnection? How can we store data fetched from excel file into SQL Server 2005 database?

comments postedmanuel de leonFriday, December 24, 2010 at 12:00 am

If you need to create Excel 2007/2010 files, try this open source: http://closedxml.codeplex.com

comments postedbrand cooperationTuesday, January 25, 2011 at 9:57 pm

Thanks for sharing these details, it will be great to use on my ownwebsitemanage data.

comments postedengmar himselfTuesday, February 1, 2011 at 1:35 pm

It should indicate where the file resides; for me it didn't work until the folder where the excel file was located had directory browsing permissions (.net 1.1) - when reading the file on the same system as the browser, the folder permissions What are the precautions? running?

comments postedswatiWednesday, February 2, 2011 at 2:50 pm

Thanks Westham it's working now.

comments postedLauer saysMonday, February 7, 2011 at 1:27 am

Can we get data from .slk file?

comments postedshital pawar, megha kharadeThursday, March 10, 2011 at 6:38 am

¡ ¡ Thanks!
Connect using this connection string
string connString = "Vendor=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + Server.MapPath("Sheet1.xls") + ";" + "Extended Properties=Excel 12.0;";

comments postedjessieFriday, March 25, 2011 at 12:54 pm

Hello everyone,

This code is perfect.

If for some reason it doesn't work for you, make sure you have the correct ACE driver loaded. It is required to work with Office 2007 files. Also, in your solution, make sure that the OleDB reference is properly set. It won't work any other way. Thank you!

comments postedVacasMonday, March 28, 2011 at 8:37 am

Hi, I did the same code but it shows error "No connection found".
Can someone please tell me the problem?

Thanks

comments postedNick LaMotteWednesday March 30, 2011 at 7:51 PM

I had to use Server.MapPath("~/") to map the full path to the .xls file of the datasource in the connection string to get it to work. I get the error: "The Microsoft Jet database engine cannot find the object 'Sheet1'. Please ensure that the object exists and that you have spelled its name and pathname correctly"

comments postedborisMonday, April 18, 2011 at 4:01 pm

This is the best way http://excelpackage.codeplex.com/

comments postedTreveFriday, April 22, 2011 at 1:43 pm

Thanks for posting this code, it worked for me almost immediately (I'm using Windows 7 Ultimate with asp.Net3.0, C# code-behind, Office 2007). The only exception error is that it cannot open a connection to an already open file, so it seems to me to be a permission error using Win 7. But when trying 'string connString="Provider=Microsoft.ACE.OLEDB.12.0 ;" + "Data Source=" + Server.MapPath("Sheet1.xls") + ";" + "Extended Properties=Excel 12.0;"; ' Thanks to "shital pawar, Megha Kharade", it's working fine now, greetings to all.

One thing to note is that no one is mentioned in your C# code, you need to add some references so that it recognizes the OleDb and Dataset classes. (copy/paste into c# code behind .cs page)

Use System.Data.OleDb; // Requires OleDbConnection, OleDbCommand, OleDbDataAdapter
Use system data; // Required for datasets

Thanks

comments postedTreveThursday, April 28, 2011 at 2:54 pm

Hello again. Ok, now we're faced with this "pretty good" approach, only to find that it only works on localHost and not on live servers, because "Provider 'Microsoft.ACE.OLEDB.12.0' is not registered on the local machine. (Even though it was created with I'm testing on the same machine locally!), so I'm sure other people get the same error, but it's not really involving anyone here. Any idea how to avoid this?

If I find one in the meantime, I'll post it.

healthy

comments postedWarrenTuesday, May 24, 2011 at 8:11 am

good article. works great, but i want to know why you write $ sign with leaf and what do you mean by writing [leaf $]

comments postedrareTuesday, May 31, 2011 at 12:26 pm

Got the following exception:

The Microsoft Jet database engine could not find the object 'Sheet2$'. Make sure the object exists and that you typed its name and path correctly.

to do? Please help :( this is urgent

comments postedrareTuesday, May 31, 2011 at 12:37pm

Got the following exception:

The Microsoft Jet database engine could not find the object 'Sheet2$'. Make sure the object exists and that you typed its name and path correctly.

to do? Please help :( this is urgent

comments postedsareeThursday, July 21, 2011 at 2:16 pm

Actually i want to know how to get integer value from xl table to asp.net code. It takes a string value instead of an int value.

comments postedSaturdayTuesday, August 9, 2011 at 9:47 pm

Easy way to read data from excel files (xls, xlsx) without ole automation,
http://www.e-iceblue.com/Introduce/excel-for-net-introduce.html

comments postedSoviet UnionTuesday, October 11, 2011 at 4:08 pm

Thanks for posting this code. This is really helpful... Is there something I should change in the connection string code? If I want to connect to a remote file...

comments postedSonaliMonday, October 24, 2011 at 12:25 am

What is an "employee" in code?

comments postedSonaliMonday, October 24, 2011 at 12:45 am

What is an "employee" in code?

comments postedkapil developerThursday, November 17, 2011 at 7:21 am

Please send me the connection string for excel 2010 to connect with asp.net 3.5

Thanks

comments postedroyal landWednesday, November 23, 2011 at 11:49 pm

For users who get the error message: "The Microsoft Jet database engine cannot find the object 'Sheet1$'. Please ensure that the object exists and that you have spelled its name and pathname correctly."

Make sure you have the desired file extension (.xlx, .xlsx, etc.)

comments postedLightMonday, December 5, 2011 at 10:40 PM

I tried your VB code but my output is NULL or not displayed. I just followed your code and also changed your datasource path. please help.

comments postedManMonday, January 16, 2012 at 8:33 am

If you don't know the name of the excel sheet, you can look at the name,
conn = new OleDbConnection(connString);
// open the connection
如果 (conn.State == ConnectionState.Closed) conn.Open();
//Create command object

dtSceama = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
if (dtSceama != null)
{
String[] excelSheets = new String[dtSceama.Rows.Count];
int i = 0;

// Add the worksheet name to the string array.
foreach(file DataRow en dtSceama.Rows)
{
excelSheets[i] = fila["TABLE_NAME"].ToString();
yo++;
}

query = "SELECT * FROM [" + excelSheets[0] + "]";
cmd = new OleDbCommand(query, connect);
da = nuevo OleDbDataAdapter(cmd);
da.Fill(ds);
cmd.Dispose();
from.Dispose();

}
conn.Close();

comments postedManMonday, January 16, 2012 at 9:12 am

If you don't know the name of the excel sheet, you can look at the name,
conn = new OleDbConnection(connString);
// open the connection
如果 (conn.State == ConnectionState.Closed) conn.Open();
//Create command object

dtSceama = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
if (dtSceama != null)
{
String[] excelSheets = new String[dtSceama.Rows.Count];
int i = 0;

// Add the worksheet name to the string array.
foreach(file DataRow en dtSceama.Rows)
{
excelSheets[i] = fila["TABLE_NAME"].ToString();
yo++;
}

query = "SELECT * FROM [" + excelSheets[0] + "]";
cmd = new OleDbCommand(query, connect);
da = nuevo OleDbDataAdapter(cmd);
da.Fill(ds);
cmd.Dispose();
from.Dispose();

}
conn.Close();

comments postedthey packTuesday, January 17, 2012 at 4:23 am

Bonita

comments postedSantoshTuesday, February 21, 2012 at 4:55 am

Hello,
My excel file columns contain numbers and text, both data types.
Excel only reads one type of data, either numeric or text format.
I want to read both types of data. Provide me a solution on how to read these two types of values.

comments postedEricFriday, March 2, 2012 at 5:41 am

Why employees?

comments postedAmreshThursday, March 15, 2012 at 1:52 pm

How to update, delete and insert records in excel file using asp.net gridview.
Please explain with code.
Thanks in advance.

comments postedGayatriFriday, April 6, 2012 at 10:48 am

Hello,

I'm having trouble restoring an updated Excel sheet. Code works just fine. However, if I add another field or cell to the sheet, I don't see the updated information when I build the solution again. I am new to asp.net. Can anyone help?

comments postedVimalaFriday, May 18, 2012 at 5:19 pm

@evryone....thank you...nice article, especially deeraj...can someone from excel tell me how to extract the name from the worksheet and extract the data based on column header and column value, do i need to retrieve a specific row? Please reply to this and my mail: vimaladave@gmail.com

comments postedValariSunday, July 8, 2012 at 11:45 PM

{"The Microsoft Office Access Database Engine cannot open or write to the file ''. It is opened exclusively by another user, or you need permission to view and write its data."}
How to do... I use c# and excel2007

comments postedValariSunday, July 8, 2012 at 11:58 PM

{"The Microsoft Office Access Database Engine cannot open or write to the file ''. It is opened exclusively by another user, or you need permission to view and write its data."}
How to do... I use c# and excel2007

comments postedBetoWednesday, August 15, 2012 at 6:26 am

According to Microsoft,

"The Access 2010 Redistributable Database Engine is not designed to:
...
Intended for use by system services or server-side programs where code will run under the system account, or will handle multiple user identities concurrently, or is highly reentrant and expects stateless behavior. Examples include programs that run from Task Scheduler when no user is logged on, or programs that are called from server-side Web applications such as ASP.NET, or distributed components that run under COM+ services.

My understanding is that it opens a new object each time it is called and never releases it.

Beto

comments postedafternoonTuesday, February 26, 2013 at 11:12 am

Hi I tried your code to read data from excel into winform application. but it doesn't work it says
Additional Information: The provider 'Microsoft.Jet.OLEDB.4.0' is not registered on the local computer.

Can you tell me how to solve this problem?

comments postedAlexisTuesday, October 15, 2013 at 8:05 am

If you want your code to read your excel files in ASP.NET, I recommend you to use this .NET library from Aspose: http://www.aspose.com/.net/excel-component.aspx

FAQs

How to read data from excel file in asp net? ›

How to Read Excel File in Data Set Using ASP.Net
  1. First of all, open a new Excel Sheet and enter the information that you want to add. ...
  2. Now you need to add a Drop Down List, a List Item, a Label, and a Grid View to your application. ...
  3. Now add this code in the selected index change of the drop-down list:
Jan 3, 2021

How do I read data from an XLS file? ›

Example of reading excel file (.xls) file
  1. import java.io.File;
  2. import java.io.FileInputStream;
  3. import java.io.IOException;
  4. import org.apache.poi.hssf.usermodel.HSSFSheet;
  5. import org.apache.poi.hssf.usermodel.HSSFWorkbook;
  6. import org.apache.poi.ss.usermodel.Cell;
  7. import org.apache.poi.ss.usermodel.FormulaEvaluator;

How to get data from .xls file in C#? ›

How to Read Excel File in C#
  1. Download the C# Library to read Excel files.
  2. Load and read an Excel file (workbook)
  3. Create an Excel workbook in CSV or XLSX.
  4. Edit cell values in a range of cells.
  5. Validate spreadsheet data.
  6. Export data using Entity Framework.

Which function allows you to read an excel data sheet data XLS? ›

num = xlsread( filename ) reads the first worksheet in the Microsoft® Excel® spreadsheet workbook named filename and returns the numeric data in a matrix. num = xlsread( filename , sheet ) reads the specified worksheet.

How to read XLSX File in asp net Core? ›

Steps for reading Excel files
  1. Create or use an existing . NET Core project.
  2. Download and install GemBox. Spreadsheet Setup.
  3. Add a reference to GemBox. Spreadsheet. dll within your . NET Core project.
  4. Optionally, you can add GemBox. Spreadsheet Nuget package to your C# or VB.NET project.
  5. Execute the C#/VB.NET code below.
Aug 21, 2020

How to import data from excel File to database table in asp net? ›

After it inserts into the DataTable in the database, or write the following code in the httppost method.
  1. [HttpPost]
  2. public ActionResult Index(HttpPostedFileBase file)
  3. {
  4. DataSet ds = new DataSet();
  5. if (Request.Files["file"].ContentLength > 0)
  6. {
  7. string fileExtension =
Apr 20, 2021

Which software read XLS file? ›

6 Ways to Open XLS and XLSX Files for Free
  1. Office Editing for Docs, Sheets & Slides.
  2. Google Sheets.
  3. LibreOffice Calc.
  4. Apache OpenOffice.
  5. Aspose Excel Viewer.
  6. Zoho Sheet.
Feb 21, 2023

How do I view XLS as XML? ›

Click File->Open in MS-Excel to begin. To open the XML file, navigate to the location where it is stored and select Open. A pop-up window appears with three possibilities. Choose the radio button that says "As an XML table."

How to read data from Excel in Visual Studio? ›

Code playground
  1. Open Visual Studio. Select New Project, then Windows Form Application. ...
  2. Name it as you want. My application name is ReadExcelFileApp.
  3. First of all, add Reference of the Excel library - IronXL. ...
  4. Browse tab type “IronXL.
Sep 28, 2022

How to read Excel file using Aspose in C#? ›

Read an Excel File in C#
  1. Get a reference of the worksheet in a Worksheet object.
  2. Get a count of data rows and columns in the worksheet.
  3. Start a loop for rows.
  4. Start a nested loop for columns.
  5. Read data from each cell using Worksheet. Cells[i, j]. Value property.
Oct 10, 2021

How to convert XLS to XLSX in C#? ›

Convert XLS to XLSX in C# and VB.NET
  1. Create a Workbook instance.
  2. Load the XLS file using Workbook. LoadFromFile() method.
  3. Save the XLS file to XLSX format using Workbook. SaveToFile(string, ExcelVersion) method.

How to read Excel file with file path in C#? ›

The following shows three methods in button click event.
  1. ///<summary>
  2. ///Upload File to Temporary Category.
  3. ///</summary>
  4. private void Upload() {
  5. HttpPostedFile file = this.fileSelect.PostedFile;
  6. string fileName = file.FileName;
  7. string tempPath = System.IO.Path.GetTempPath(); //Get Temporary File Path.
Nov 23, 2020

Can Excel read XLS? ›

xls file is associated with Excel by your PC. This means that when you double-click on a file in Windows Explorer, the file will automatically open in the version of Excel on your computer.

Which activity can be used to read an entire sheet from an Excel file? ›

What activity can be used to read an entire sheet from a excel file? If you need to sort a table from an . xlsx file, what should you use? 1) An Excel Sort data table activity.

What type of Excel file is XLS? ›

The Microsoft Excel Binary File format, with the . xls extension and referred to as XLS or MS-XLS, was the default format used for spreadsheets in Excel through Microsoft Office 2003. The format is also referred to as Binary Interchange File Format (BIFF) in Microsoft's technical documentation.

How to read and write Excel File in asp net c#? ›

Steps to read and write data from Excel using C#
  1. Step 1: Create a new C# project in Visual Studio. ...
  2. Step 2: Add COM Component Reference i.e. Excel 14 Object. ...
  3. Step 3: Import the namespaces in C# code. ...
  4. Step 4: Write Data to Excel File. ...
  5. Step 5: Read Data from Excel File. ...
  6. Step 6: Run the C# Program.
Mar 6, 2023

How to read a File in asp net? ›

how to read or write text file using asp.net
  1. WriteAllLines: Creates a new file, writes one or more strings to the file, and then closes the file.
  2. ReadAllLines: Opens a text file, reads all lines of the file into a string array, and then closes the file.
  3. AppendAllText: Appends lines to a file, and then closes the file.

How to read data from Excel in ASP NET MVC? ›

Read Excel Files in ASP.NET MVC Using IronXL
  1. Install C# library to read excel file in ASP.NET.
  2. Load and access the targeted sheet in Excel file.
  3. Access ToDataTable method and return to it View.
  4. Display Excel data on a web page by using loop.
  5. Iterate through all data and build HTML table from it.

How to get data from database table in asp net? ›

The following is the procedure for retrieving the data from the database.
  1. First we create a table and insert some data into this table. ...
  2. Create ASP.NET Web API application. ...
  3. Now add the Entity Framework to our application. ...
  4. Now open the Entity Data Model Wizard. ...
  5. In this step: ...
  6. In this step: ...
  7. Open the Home controller.
Jan 7, 2021

How to upload an Excel spreadsheet in asp net? ›

Now switch to design mode and double click on upload button and put the following code to validate the Only Excel files to be allowed to upload.
  1. protected void Button1_Click(object sender, EventArgs e) {
  2. Label2.Visible = true;
  3. string filePath = FileUpload1.PostedFile.FileName; // getting the file path of uploaded file.
Jan 5, 2021

Is CSV and XLS the same? ›

The difference between CSV and XLS file formats is that CSV format is a plain text format in which values are separated by commas (Comma Separated Values), while XLS file format is an Excel Sheets binary file format which holds information about all the worksheets in a file, including both content and formatting.

What is the difference between XLS and Excel file? ›

Microsoft Excel 2007 and later uses XLSX as the default file format when creating a new spreadsheet. Support for loading and saving legacy XLS files is also included. XLS is the default format used with Office 97-2003. XLS is a Microsoft proprietary Binary Interchange File Format.

What is the difference between read CSV and read XLS? ›

Key Difference between CSV and Excel

CSV is a plain text format with a series of values separated by commas, whereas Excel is a binary file that holds information about all the worksheets in a workbook. CSV file can't perform operations on data, while Excel can perform operations on the data.

How do I convert Excel XLS to XML? ›

xml) instead of using the Export command.
  1. Press Ctrl+S to save your file. ...
  2. Click File > Save As, and select the location where you want to save the file. ...
  3. In the File name box, type a name for the XML data file.
  4. In the Save as type list, click XML Data, and click Save.

What is the difference between XLS and XML file? ›

XML is text based while XLS is a binary format that cannot be opened with text editors. If you try to open XLSX with a text editor, you will get garbage. That is because the XML files are archived using the ZIP format.

How to convert XLS to XML online? ›

XLS to XML
  1. Step 1 - Select a file(s) to convert. Choose Files. From my computer From my device From URL From Box From Dropbox From Google Drive From OneDrive. Drag & drop files. Max. file size 50MB (want more?) ...
  2. Step 2 - Convert your files to. Convert To.
  3. Step 3 - Start converting. Convert Now. (And agree to our Terms)

Is ExcelDataReader open source? ›

ExcelDataReader is an open source lightweight API written in C# for reading Microsoft Excel Files.

How to convert Excel to CSV in C#? ›

NET applications.
  1. Load the Excel file (XLS or XLSX) using the Converter class.
  2. Set the starting worksheet number and sheet count. ( ...
  3. Set the conversion format of the output file as CSV using SpreadsheetConvertOptions.
  4. Call the Convert method to transform the spreadsheet data or and specific pages into CSV format.
Aug 18, 2021

How do I extract data from a macro in Excel? ›

To extract data from another workbook using a Macro, you have to provide the workbook name and full path to a procedure (or a piece of code) to process. You can hard code the file name and path, store it in a variable, and then process it.

How to read Excel file and insert into database in C#? ›

Create a function to read and insert an Excel File into the database as:
  1. private void InsertExcelRecords(string FilePath)
  2. {
  3. ExcelConn(FilePath);
  4. Query = string. ...
  5. OleDbCommand Ecom = new OleDbCommand(Query, Econ);
  6. Econ. ...
  7. DataSet ds=new DataSet();
  8. OleDbDataAdapter oda = new OleDbDataAdapter(Query, Econ);
Apr 8, 2021

How to read a macro in Excel using C#? ›

Extract VBA Macros from an Excel File using C#
  1. Create an object of the Workbook class to load the Excel file.
  2. Access each VBA module from Workbook. VbaProject. Modules collection into VbaModule object.
  3. Retrieve code from each module using VbaModule. Codes property.
Dec 21, 2020

How to convert XLS to CSV? ›

Convert XLS to CSV
  1. Open the Import file. This can be done through a spreadsheet software such as Microsoft Excel or Google Sheets, but can also be done in TextEdit (Mac) or Notepad (Windows)
  2. Select File.
  3. Click Save As.
  4. Rename the file if you prefer then select . csv (Comma delimited.)
  5. Click Save.

Why convert XLS to XLSX? ›

XLSX files have the same functionality as XLS files in that they can include shapes, charts, formula, macros and more. The difference between the two is more technical. The XLSX file data is stored in the Open XML format which stores data as separate files and is zipped to reduce space.

How to export XLSX File in asp net c#? ›

How to Export to Excel in C#
  1. Download the C# Library to Export Excel files.
  2. Write extension name while importing or exporting files.
  3. Export an Excel file using the .xls extension.
  4. Export .xlsx or .xls file to a .csv.
  5. Export .xlsx file data into .XML.
  6. Export .xlsx file data into .JSON.

How to read a file in asp net using C#? ›

The File.ReadAllText() method opens a text file, reads all the text in the file into a string, and then closes the file. The following code reads a text file into a string. The File.ReadAllLines() method opens a text file, reads all lines of the file into a string array, and then closes the file.

How to read a file in Visual Studio C#? ›

Read a text file
  1. Create a sample text file in Notepad. ...
  2. Start Microsoft Visual Studio.
  3. On the File menu, point to New, and then select Project.
  4. Select Visual C# Projects under Project Types, and then select Console Application under Templates.
  5. Add the following code at the beginning of the Class1.cs file:
May 7, 2022

How to read Excel file and import data from Excel to SQL Server in C#? ›

This is one approach to the workflow:
  1. Create your form for the upload.
  2. Create your DB Structure.
  3. Create your connection string to communicate with the DB. ...
  4. Create the Form structure to handle the excel reading as well sending the data to the DAO class for the bulk Upload. ...
  5. Create your DAO class to save the data into the DB.

Is XLS obsolete? ›

Excel isn't going away anytime soon. In fact, it has become more important than ever, as it is now central to the workflow for many and used alongside other data tools such as Power BI and Tableau, and ERP systems such as SAP and Salesforce.

Does Power Query work for XLS files? ›

Power Query allows a user to import data into Excel through external sources, such as Text files, CSV files, Web, or Excel workbooks, to list a few.

Is XLS file editable? ›

Enable or disable Edit mode

Click File > Options > Advanced. , click Excel Options, and then click the Advanced category. Under Editing options, do one of the following: To enable Edit mode, select the Allow editing directly in cells check box.

What is the best way to pull data from multiple worksheets in Excel? ›

Combine by position
  1. Open each source sheet and make sure that your data is in the same position on each sheet.
  2. In your destination sheet, click the upper-left cell of the area where you want the consolidated data to appear. ...
  3. On the Data tab, in the Data Tools group, click Consolidate.

How do I make an entire Excel workbook read only? ›

Lock or unlock a workbook to make it read-only
  1. On the File menu, click Info.
  2. Click on Protect Workbook and select the Always Open Read-Only.

Which Excel function can be used to extract data from another worksheet answer? ›

While working in Excel, we will often need to get values from another worksheet. This is possible by using the VLOOKUP function. In this tutorial, we will learn how to pull values from another worksheet in Excel, using VLOOKUP.

Which format is better XLS or XLSX? ›

For compatibility, XLS has higher compatibility than XLSX. XLS is readable by all Microsoft Excel versions while XLSX is only readable by Excel 2007 and later versions. besides, XLS is able to hold the spreadsheets either including Macros or not, while XLSX isn't capable to support Macros.

What is the purpose of an XLS file? ›

An XLS file is a spreadsheet file that can be created by Excel or other spreadsheet programs. The file type represents an Excel Binary File format.

Is Excel XLS or CSV? ›

xls are two different file extensions containing data, where in CSV, the data is in the text format, separated by commas, while in Excel or . xls, information is in the tabular form with rows and columns.

How to read data from CSV file in asp net? ›

For reading the text from CSV file, you need to import the following namespace. When the Import button is clicked, the CSV file is first uploaded and then saved within a folder named Files. The CSV file information is browsed into a String variable using the File class ReadAllText method.

How to read and write excel File in asp net c#? ›

Steps to read and write data from Excel using C#
  1. Step 1: Create a new C# project in Visual Studio. ...
  2. Step 2: Add COM Component Reference i.e. Excel 14 Object. ...
  3. Step 3: Import the namespaces in C# code. ...
  4. Step 4: Write Data to Excel File. ...
  5. Step 5: Read Data from Excel File. ...
  6. Step 6: Run the C# Program.
Mar 6, 2023

How to read data from database in asp net? ›

Showing Some Data In ASP.NET From SQL Server Database Using SELECT Query
  1. Create an ASP.NET Project in Visual Studio.
  2. Create Database in SQL Server.
  3. Connect to SQL Server using Code.
  4. Connect to Database and Perform Select query.
  5. Show the values in web form.
  6. Then Read.
Nov 3, 2015

How do I read a CSV file and display its contents? ›

Example 1: Read CSV files with csv.

reader() is used to read the file, which returns an iterable reader object. The reader object is then iterated using a for loop to print the contents of each row. Now, we will look at CSV files with different formats.

Which method is used to read data from CSV? ›

Read CSV Files Using .readlines()

.readlines() method is the answer.

Which command is used to read the data from CSV file? ›

Using the Pandas Library

It contains the .read_csv() method we need in order to read our csv file.

How to read Excel file as CSV in C#? ›

How to Read a CSV File in C#
  1. Download and install the C# CSV reading library.
  2. Create a C# or VB project.
  3. Add the code example from this page to your project.
  4. In the code, specify the path to the CSV, and the output name & file format.
  5. Run the C# project to view the document.

How to bind data in ASP.NET using C#? ›

How to create Data Binding in ASP.NET?
  1. Click on Create a new project after opening Visual Studio.
  2. From the New Project Wizard Box select WPF App(.NET framework)
  3. Hit Next and then hit Create after configuring the basic details.
  4. Shell WEPF application will be created. ...
  5. Add the below code as TextProperty of TextBlock.
Apr 12, 2021

How to read data from database table? ›

The syntax is: SELECT column1, column2 FROM table1, table2 WHERE column2='value'; In the above SQL statement: The SELECT clause specifies one or more columns to be retrieved; to specify multiple columns, use a comma and a space between column names.

What database does ASP.NET use? ›

ASP.NET allows the following sources of data to be accessed and used: Databases (e.g., Access, SQL Server, Oracle, MySQL) XML documents.

How do I read data from a file? ›

The basic steps in reading data from a file are:
  1. Tell the program where to find the data.
  2. Open a path to the data.
  3. Set up the program variables to access the data.
  4. Read the data.
  5. Close the data path.

How to read all files from a folder in asp net? ›

Here I get all the files from the directory to show in the DataList control.
  1. private void GenerateDownloadLinks()
  2. {
  3. string path = Server.MapPath("~/UploadFile");
  4. if (Directory.Exists(path))
  5. {
  6. DataTable ShowContent = new DataTable();
  7. ShowContent.Columns.Add("Icon", typeof(string));
Feb 1, 2021

How to read data from file in shell script? ›

Reading File Content Using Script
  1. #!/bin/bash.
  2. file='read_file.txt'
  3. i=1.
  4. while read line; do.
  5. #Reading each line.
  6. echo "Line No. $ i : $line"
  7. i=$((i+1))
  8. done < $file.

Videos

1. C# Read data from Excel | Video | NPOI
(dastutorials)
2. Import Excel Data to ASP.NET MVC
(Learning Programming)
3. How to read Excel files in C#
(Darren Does Everything)
4. How to Read Excel File with ExcelDataReader Library in C# visual studio | Open and Read Excel Files
(Programming Guru)
5. C# Tutorial | Import Excel Sheet Data to GridView in Asp.Net C#
(Swift Learn)
6. How to Import data from Excel File to Database Table in ASP.NET Core
(Csharp Space)

References

Top Articles
Latest Posts
Article information

Author: Golda Nolan II

Last Updated: 08/15/2023

Views: 6521

Rating: 4.8 / 5 (78 voted)

Reviews: 85% of readers found this page helpful

Author information

Name: Golda Nolan II

Birthday: 1998-05-14

Address: Suite 369 9754 Roberts Pines, West Benitaburgh, NM 69180-7958

Phone: +522993866487

Job: Sales Executive

Hobby: Worldbuilding, Shopping, Quilting, Cooking, Homebrewing, Leather crafting, Pet

Introduction: My name is Golda Nolan II, I am a thoughtful, clever, cute, jolly, brave, powerful, splendid person who loves writing and wants to share my knowledge and understanding with you.