Databases :: Reading Excel File Without Saving To Disk First?

Aug 31, 2010

I need to be able to read an excel file from a file upload control but I can not save the file to disk first, it must be done in memory.


Above is my code for reading the data file if it IS saved to disk, but again, I have to be able to do this without saving the file to disk, it must be done in memory. I have not been able to find any sample code anywhere on how to do this from memory, everything seems to force the file be uploaded, saved to disk, and then read in the connection string, which again I can not do.

View 2 Replies

Similar Messages:

Databases :: Page Times Out Reading Excel File?

Mar 31, 2010

I have some code that reads records from an excel file and then imports that data into an sql database. The issue only happens when the excel file has more then 350 rows in it. In the middle of the import it just stops executing and I get directed to the 'Internet Explorer cannot display the webpage' page or just a blank page when using firefox.

I dont get any time out errors or any error at all but still I tried messing around with the script timeout settings but still does the same thing at about the 2 min 30 sec mark.


View 2 Replies

Databases :: Reading Hyperlinked Page In Excel File Using C#?

Nov 19, 2010

I understand how to use a connection string object to read excel sheets. What I don't know is how to follow a hyperlink inside excel, grab matching data from the linked page and return it to my database. Essentially, the spreadsheet has two columns:

Title | Class#

Class# has the hyperlink which links to an internal web site. The connected page has a course description and any pre-required classes that must be taken before you can take this class. This is where I'm rather stumped as I've not had to do this type of thing before.

View 4 Replies

Databases :: Upload And Import Excel File Without Saving First?

Apr 13, 2010

I need to be able to have a user upload an excel file, then immediately work with that file and save the contents in a database.

I know how to do this if I save the file first, then open it using OleDB, BUT I would rather not save it first.

View 3 Replies

Databases :: Upload An Excel File And Read In Memory Without Saving?

Mar 15, 2011

I need to upload an excel file using a web application. Then I need t oread it in memory without saving it on the server.

Does the file need to have headers? Also the data is such that it may have or may not have values for some columns.

View 1 Replies

Databases :: Reading From Excel File With Warning 'number Stored As Text'

Jun 8, 2010

in my application i have to read from an excel files and check the value of every cell i'm using an OleDb connection to open it and reading but i have this issue if some of the cells in the excel sheet is having this warning when i try to read it returns DBNull ??could any one give me a clue ....knowing that i can not force the user for not having this warning ...i have to solve this within my code .

View 5 Replies

Avoid Saving New File On The Disk?

Mar 8, 2010

I am using ASP.NET 3.5 with iTextSharp and I have the following code:

var templatePath = Server.MapPath(@"~/Templates/template1.pdf");
var newFilePath = Server.MapPath(@"~/TempFiles/new.pdf");
PdfReader pdfReader = new PdfReader(templatePath);
PdfStamper pdfStamper = new PdfStamper(pdfReader, new FileStream(newFilePath, FileMode.Create));
AcroFields pdfFormFields = pdfStamper.AcroFields;
pdfFormFields.SetField("Box1", "007");
pdfFormFields.SetField("Box2", "123456");
pdfStamper.FormFlattening = false;
Response.Buffer = true;
Response.ContentType = "application/pdf";
Response.AddHeader("Content-Disposition", "attachment;filename=new.pdf"));

The above code fills out a pdf file and saves the new file to the TempFiles folder. It then prompts the user to either save or open the file. Can I achieve the same functionality without saving the file to the TempFiles location?

View 1 Replies

C# - How To Preview A HTML File In Another Tab/window Without Saving It On Disk

Jan 5, 2011

In my application I store a string as content of a HTML file.

How can I preview this content (assuming that it's modified from original content) in browser but not having to save it to disk locally.

And the preview to be in another tab or window.

View 5 Replies

SQL Server :: Writing/Saving DataType Image As File To Disk?

Mar 16, 2011

i need to save multiple documents stored in SQL server as Image type to disk.

What i want to do is "backup" all files in a table (column) to disk, zip them and Response.TransmitFile(FilePath) to client.

I could use C# ot VB but that would require a lot of connections to database or a lot of server memory and i don't want that, becauze there are a lot of files to be saved Since SQL can write files to disk i was thinking about saving those files to disk directly from sql. Something like when u're doing a backup


View 6 Replies

Web Forms :: Can Uploaded Tiff File Be Converted To Jpeg Before Saving To Disk?

May 10, 2010

My website provides a facility to upload images, using the ASP.NET FileUpload control. We accept both jpeg and tiff formats but I have just decided that all tiffs should be converted to jpegs at the time of upload. If possible, I want to avoid saving the original tiff to disk. I would any sample coding for achieving this conversion prior to saving (ideally in VB.NET, though I could always run C# code through a converter).

View 4 Replies

Web Forms :: Uploaded Tiff File Be Converted To Jpeg Before Saving To Disk?

Jan 6, 2011

My website provides a facility to upload images, using the ASP.NET FileUpload control. We accept both jpeg and tiff formats but I have just decided that all tiffs should be converted to jpegs at the time of upload. If possible, I want to avoid saving the original tiff to disk.

I would appreciate any sample coding suggestions for achieving this conversion prior to saving (ideally in VB.NET, though I could always run C# code through a converter).

View 31 Replies

Attach File To Email Attachment Directly From FileUpload Without Saving On Disk

Nov 5, 2012

how to add an attachement to an email from the fileupload without saving the document

to the server.

View 1 Replies

Databases :: Saving Data From Excel?

Oct 1, 2010

I need the ability for a user to browse to an Excel sheet stored on his local machine and save the contents into a database table.

View 1 Replies

Databases :: Reading Data From An Excel Workbook (.xls)

Mar 1, 2011

I have a scenario where I have to read an excel file to dump records in a mysql database. The code generates an exception Sheet1 not found. I have pasted the code below. Please let me know the solution to the exception. I have given the correct read/write/modify settings to my excel file.

if (fileUpload1.PostedFile.FileName.EndsWith(".xls") || fileUpload1.PostedFile.FileName.EndsWith(".XLS"))
string fileName = Server.MapPath(fileUpload1.PostedFile.FileName);
string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + ";Extended Properties=Excel 8.0";
// Create the connection object
OleDbConnection oledbConn = new OleDbConnection(connString);
// Open connection
// Create OleDbCommand object and select data from worksheet Sheet1
OleDbCommand cmd = new OleDbCommand("SELECT * FROM [Sheet1$]" , oledbConn);
// Create new OleDbDataAdapter
OleDbDataAdapter oleda = new OleDbDataAdapter();
oleda.SelectCommand = cmd;
// Create a DataSet which will hold the data extracted from the worksheet.
DataSet ds = new DataSet();
// Fill the DataSet from the data extracted from the worksheet.
oleda.Fill(ds, "RestaurantExcelData");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
Response.Write("Data: " + ds.Tables[0].Rows[i].ItemArray[0].ToString() + "");
catch(Exception e1)
// Close connection
Response.Write("File Not Excel (xls||XLS)");

View 2 Replies

Databases :: Reading Excel Data To SQL Database

Sep 23, 2010

Using C# to develop an application.I need to upload data ( which is in excel) to a sql table.


View 1 Replies

Databases :: Reading Data From Excel 2007?

Aug 3, 2010

I am attempting to read data from an uploaded spreadsheet using ACE.OLEDB. The code, which is running fine on dev and test machines for XL2003/2007 reports "Exernal table is not in the expected format" error on connecting on the production server for XL2007 only.The code is

Dim connectionString As String = "provider=Microsoft.Ace.OLEDB.12.0;" _ & "Data Source='" & ImportData.FullName & "';Extended Properties=Excel 12.0;" LogWebActivity.LogThis("Entering POPSUKD, ConStr=" & connectionString, LogWebActivity.LogDetailLevel.DetailAndData) Dim con As New System.Data.OleDb.OleDbConnection(connectionString) LogWebActivity.LogThis("Dimmed con", LogWebActivity.LogDetailLevel.Debugging) Try Dim cmdSelect As New System.Data.OleDb.OleDbCommand("SELECT * FROM [" & WorksheetName & "$]", con) Dim adapter As New System.Data.OleDb.OleDbDataAdapter(cmdSelect) Dim dS As New Data.DataSet LogWebActivity.LogThis(cmdSelect.CommandText, LogWebActivity.LogDetailLevel.Debugging) con.Open() LogWebActivity.LogThis("Opened Connection", LogWebActivity.LogDetailLevel.Debugging) adapter.Fill(dS, WorksheetName) LogWebActivity.LogThis("Filled DataAdapter", LogWebActivity.LogDetailLevel.Debugging) _SKUS = dS.Tables(WorksheetName) LogWebActivity.LogThis("Set SKUS", LogWebActivity.LogDetailLevel.Debugging)

View 1 Replies

Databases :: Reading And Writing MS Excel (2007) Files?

Mar 4, 2011

Want to create a web based application for reading and writing excel files.

Issue :

1. Want to upload an excel file and store it some location.
2. Read data from excel file, performing some sorting and filtering
3. Write filtered data to new excel file.

View 1 Replies

Databases :: Reading From An Excel Spreadsheet - Fields With Numbers Are Showing As DBNull

Nov 8, 2010

My web app is allowing the user to load a column of data from an Excel spreadsheet. For whatever reason, as it parses the data, fields that are just integers are coming up as System.DBNull. (Code in VB.NET but I work with C# as well, so feel free to post C# solutions)


dataRow(0) is System.DBNull when the Excel file has a number in Column A. Here's what the Excel looks like

Column A
123456 and 119655902 come through as DBNull

View 8 Replies

Web Forms :: Reading A File Into Stream And Saving It To A Location?

Oct 8, 2010

I have a third party CMS system that can create forms but can't manage true File upload capabities. I am able to get users brows for thier file and have the value submited to my custom .net code behind page for processing. So I end up with like "C:somefilefoldersomefile.doc".

But on my processing page I want to read this file (like the file uploader) and save it to a location. I tried using the file uploader control (but have it not visible) but realized I can't preset it as I was planning to set it and do the normal processing from there. Is there another way to do this?

View 3 Replies

Web Forms :: Export Data From Web Into Excel And Save The File On Server On Disk?

Aug 20, 2012

i want to export an excel from my web application and want to save it on Web Server, but i am not able to save it on web server, i am able to do it on my local machine, but on web server it's not working.

View 1 Replies

DataSource Controls :: Reading From SQL Server And Saving As Physical File

Mar 26, 2010

I have to create PDF Files reading data from SQL Server where the data is in Binary format as Image data type.

View 2 Replies

Databases :: Upload Ms Word File And Store It Into Database Then Reading The File?

Jan 12, 2011

i like to create a web application,in that i need to get the resumes from the user,then i need to publish that resume to the manager in date wise..

View 5 Replies

Databases :: Reading Tab Delimited Xls File?

Nov 29, 2010

I have tab delimited .xls file. I want read this to a dataset. Oledb connection string is given below. But i'm getting one error on objConn.Open();

string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties=Excel 8.0";
OleDbConnection objConn = new OleDbConnection(strConn);
Error : External table is not in the expected format.

How can i read tab delimited .xls file to a dataset using oledb connection?

View 5 Replies

Databases :: Reading Text File Into DataReader?

Jul 8, 2010

I'm trying to read data from a text file into a DataReader object using the following code but I get an exception:

OleDBException was unhandled.

Cannot update. Database or object is read-only.

Also, I would like to know if it is efficient to read data of a text file into a datatable instead of using StreamReader object and traversing through the recordset.


View 3 Replies

Databases :: Reading CSV File From The Fileupload And Then Retrieve The Data?

Mar 4, 2010

1) I need to make reading CSV file from the fileupload and then retrieve the data.

2) I need to load CSV and the 3 columns rise two functions.

Load CSV data and then stored in a database, but I need to save storage space vary according to 3 column.

CSV Example:
1 column - Cat, 2 column - Black, 3 column - 1
1 column - Dog, 2 column - Brown, 3 column - 2
1 column - Cat, 2 column - Black, 3 column - 1
1 column - Dog, 2 column - Brown, 3 column - 2

Now I need to load the CSV in C # and column 3 to distinguish what the operation is carried out.When the load line in column 3 contain the value 1, so will save the table 'Cats' when the value 2 and is saved in the table "Dogs".(Note: Data are separated ";")

View 4 Replies

Copyrights 2005-15, All rights reserved