I have to import the contents of a spreadsheet in my asp.net project. The code behind is c#. how to locate the spreadsheet on the user's computer and how to import the data from a given worksheet into a datable. The problem is I may not know the name of the worksheet ahead of time. How do I present the user with a list of available worksheets and have them pick one?
View 2 RepliesIs there a way wherein I could import data from multiple sheets of an excel file?
View 2 RepliesI have a form that allows a user to import a spreadsheet. This spreadsheet is generally static when it comes to column headers, but now the users want to be able to include an optional column (called Notes). My code crashes when I try to read the column from the spreadsheet if it doesn't exist.
[code]...
importing excel/spreadsheet into sql server using C#? Whenever I run the webpage by selecting excel file, first it will empty sql server table then import data from excel.
View 3 RepliesI have a requirement that the user will need to import a list of ID's to the asp.net website from their own spreadsheet. I will provide a button 'btnImport' which will use an OleDbConnection to read the spreadsheet and pull in the id's. I have that working fine in my local dev environment. My question is, when this app is running on a production server, will the user have to upload her spreadsheet to the server first? Or do I need to provide code that will find the file on her machine? I'm not sure how this part of it works.
View 4 RepliesI have a VS2010 project that I want to move back and forth between an x86 and an x64 machine. On the x86 machine, several assemblies are located in Program Files, and the path of the assemblies are shown as c:Program Files...... When I move this project to the x64 machine, the same assemblies are located in C:Program Files (x86).... Is there a way that I can confugure VS2010 so I don't have to manually change the path when I move the project from one machine to another?
View 1 RepliesI am exporting an aspx page as an xls (excel) file.
I have everything working fine, but am wondering if there is a way to section some data from the aspx page into different excel worksheets?
I am binding data from a dataset to a grid and exporting data from the grid to an excel.if the the number of items in the grid is greater than 50000,an error message is displayed.
So i want to split the data and display it in different worksheets in excel.(Am working in a web application)
using this code for exporting to excel
gvExcel.DataSource = DTS;
gvExcel.DataBind();
Response.AddHeader("content-disposition", "attachment; filename= filename.xls");
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gvExcel.RenderControl(htw);
// Style is added dynamically
Response.Write(style);
Response.Write(sw.ToString());
Response.End();
I need to export data to multiple worksheets based on some conditions. Currently i am able to export the data to a single sheet in excel using below code,
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + strFileName + ".xls");
HttpContext.Current.Response.Charset = "";
[code]...
I have an excel sheet with 2 tabs and has data in those 2 sheets(sheet1, sheet2) which correspond to different tables in the same database. This excel sheet gets updated daily, I am wiriting a console app( which will later be a batch build). I have to insert the data from the excel sheet to corresponding tables (table1, table2,table3) in database when i run it and and also if the table has the same data already present it should ignore and if there are any modifications done the data it should update the table. I know we can do this using ado.net or LINQ, I am a little new to database based programming .
View 4 RepliesI have multiple gridviews on a page. I would like to add these to an excel file and have a worksheet for each gridview.
I found some code on the web to accomplish this. However, when i run it i always get all the gridviews on one worksheet. The code is shown below.
Can somebody tell me how i can send multiple gridviews to an excel file to get a workbook with multiple worksheets?
[Code]....
want to export 2 gridviews to 2 worksheets in single excel file. and also don't want to use any other dll or utility or Interop assemblies.
View 7 Replieshas anyone got any pointers for recursively listing the directories and file structure within an FTP space with the built in .NET FTP client, ideally I would like to bind the results to a tree view at once.
View 3 RepliesI have a method who return list of data from database. i want to know how we can get value from list which is return by method.
public List<Company> GetCompanyInfo (int CompID)
{
db_CompanyDataContext obj_comp = new db_CompanyDataContext();
var Compnay_Info = from Cinfo in obj_comp.Companies where Cinfo.CompID == CompID
select Cinfo;
return Compnay_Info.ToList();
}
i am trying below mention statement but it gives error.
List<Company> cmp = sm.GetCompanyInfo(qry).ToList();
I am actually bit confused to say. I googled for applying styles in my spreadsheet i got some functions in which they mention about the font, borders etc which i need but i dont know where should i use or how should i implement. When i tried to implement like cell.StyleIndex=8 // Which is modified as per my need but there is no effect in the cells
View 1 RepliesPossible Duplicate: Create Excel (.XLS and .XLSX) file from C#
I have some code that generates a zip file that contains multiple CSV files and streams it back to the user (no file is saved on the server). However, I want to create an excel workbook instead (can be traditional xls or Office Open XML xlsx format) with each CSV 'file' being a spreadsheet.
How can I do this, without resorting to Office Automation on the server or a commercial 3rd party component?
I'm trying to achieve a dynamic contact lists/info. > From the Left Column, it may contain three hyperlinks that could update the list of contact lists for a specific department office. And on the Right column, I'm planning to have a loop over the data view collection from a Model(e.g. Contacts) that will be displayed after selecting any of the hyperlink from the left column.
View 2 RepliesI've just started developing a web site in VS 2008. When I try and view the page (click 'start debugging') an IE window pops up displaying a directory listing of all the files in my web application directory rather than my masterpage or content. Why is this and how can I correct it?
View 2 RepliesI'm working on a project which requires me to plot a graph using Visual Studio ASP.Net from a data I've collected either in .txt or .xml format. The data consist of, eg. 15 records, but I'm only needed to plot 8 graphs out of the 15 records.
View 1 RepliesI'm exporting an ASP.NET gridview to Excel using the following function. The formatting is working really well, except I need to freeze the header row in Excel on the export. I'm really trying to avoid using a 3rd party Excel plugin for this, but unless there's some archaic excel markup in my AddExcelStyling function.
[code]....
I have a 2 dimensional array, I want to convert it to an Excel document using C#.
View 2 RepliesI have a datasource of an excel spreadsheet provided by a customer. The data is biographic information about clients. The last row contains a web link to view an image of the subject. I have open access to download the spreadsheet and can click each image to view the full jpg in IE.
What would be the best method to loop through the image link to deposit the image into a central file location? The datasource contains 50K subjects and is updated monthly, this is why a manual process is out of the question.
I'm trying to upload an excel spreadsheet using the FileUpload control, read the excel sheet using OleDb connection, and save the strings onto a sql server database.Then, I'm trying to read each string in another method.My web app is currently hosted on the network on my local box, and using savePath= @"C:desktop" like I had it previously wasn't working, so I figured using a sql server database would work for being able to save the file and open it again... but I'm getting confused on how to do so, so i tried using my old savePath but it's not working anymore. So... I'm really at a lost on what to do and how to fix it.
[Code]....
How to do something like this without actually downloading the spreadsheet to the local machine? Any tools or what not out in the world for doing something like this? Does sharepoint allow for .xlsx editing in a page?
Anything short of writing all the inputs and mapping them with backend code?
On an .aspx page in a web site I need to retrieve some data from a sql server database and, instead of displaying it in a Gridview, I need to put the data in a spreadsheet and present the user with a Save As dialog.
I'd prefer to do it without using the Office / Excel / Interop com object - so, from what I've read so far, I can do this by returning XML data from SQL Server?
Normally I get data from SQL Server and populate a dataset or datareader with it - and then use this as the Datasource of a GridView.
If I run this in SQL Server ...
Code:
SELECT UserID, UserName FROM tblUsers FOR XML Auto, Root('Users')
It produces this ...
Code:
<Users>
<tblUsers UserID="1" UserName="Steve" />
<tblUsers UserID="2" UserName="Andrea" />
<tblUsers UserID="3" UserName="Zebedee" />
</Users>
So, first question - how do I get the data from SQL Server into my .aspx page? (All data access is done with stored procedures - so, from my data access class normally I create, for example, a SQLDataReader and populate it by calling a stored procedure. What object would I populate with the results of a stored procedure that contains a select statement with 'FOR XML Auto'
Then, assuming I get the XML into the .aspx page - how do I get it into a spreadsheet so that there are two columns called UserID and UserName and 3 rows with 1, 2 and 3 in the first cell and Steve, Andrea and Zebedee in teh second cell?