Tagged Questions
0
votes
0answers
6 views
VBA- Data from Webpage not accessible after Login
I am trying to access a web page which uses POST method. Once I enter into the
site, the user has to provide the Login and Password. Once it goes to the main
page , am trying to copy the entire ...
0
votes
1answer
22 views
Best way to export ASP.NET form data to Excel file?
I am pretty sure it is possible, I just don't know how.
I have a web form with many select dropdowns and input boxes.
How can I export the data from these asp controls into an Excel file.
I just ...
0
votes
1answer
34 views
Integrating ASP.NET Page With MS Excel as DB
I want to create a ASP.NET application which will fetch and store data from excel. For eg. currently i have automated excel reports using VBA and Macros, and user have to oem all the excels to get the ...
0
votes
1answer
70 views
Read 60,000 lines from excel sheet
I have an Excel sheet that contains round about 60,000 records(lines) with 20 columns whose file size is 36mb+. when I try to read it using a file upload control in asp.net 4.0, an error comes that ...
0
votes
0answers
27 views
How to use an Excel UDF in ASP.NET [closed]
In the last few years I developed some specific mathematical functions to be used in my field (supply chain). Since me and my colleagues extensively use Excel, I coded them as UDFs.
Now I need those ...
0
votes
1answer
27 views
ASP.NET Excel formatting and export
I've attached a pic below for better understanding of what format I want for my excel. I got no idea how to start to format excel using ASP.NET at all. Please do guide me. Thanks in advance.
0
votes
2answers
44 views
Convert xlsx to XML spreadsheet 2003 in ASP.net c# programmatically
I have a web application that reads from XML, but the users need to upload .xlsx or .xls files.
How do I programatically convert the Excel files into XML spreadsheet 2003?
-1
votes
0answers
45 views
c# Corrupted file xlsx file usgin aspGridView [closed]
I am using an ASP.net GridView to export it to an excel
this is my c# code
HttpResponse response = Response;
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new ...
0
votes
1answer
56 views
Retrieve varbinary data from SQL Server as Excel DataTable
In our application, we are saving the Excel files uploaded by the users to the database with varBinary data type. But, we would also like to retrieve back the data and be able to parse it to get the ...
1
vote
1answer
41 views
Unable to write and read a file in asp.net
I have a functionality wherein I write an excel file in a folder in application's solution and read it from there and allow save . It is working fine in local but after deploying in the server it is ...
-2
votes
1answer
273 views
Import Excel Data to SQL Server 2008 Using Visual Studio 2008 C#/ASP .NET web application
I'd like to know how to Import excel file to SQL Server 2008. For Example I have a textbox, browse button, and import button. I will click browse and will browse for the excel file then click import ...
0
votes
1answer
62 views
String Format when Export to Excel From gridview
I Have export Gridview data to excel, here's my code :
Protected Sub btnExport_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnExport.Click
Try
Dim dt As ...
0
votes
1answer
55 views
After import of excel data, big post of form with the values
I'm currently developing a web application(c#, asp.net mvc) which gonna let users upload there own data by excel files to the database MSSQL. In most of the cases the excel files will have more than ...
0
votes
2answers
71 views
Export sqldatasource to excel not just list or gridview
I'm trying to export my listview, but not just the visible listview, I want to export the entire contents of the sqldatasource. The query returns 20 columns, only a small set (5) are displayed on the ...
0
votes
2answers
83 views
ASP Table to Excel
When viewing ASPX in website, I got a table with few text in the cells, e.g.:
tab.Rows[1].Cells[1].innerHtml = "Booked :"
(In alot of rows and cells but with different text in each cell)
Now I ...
