e have a excel file which is updates dynamically, we need to design a web app which will be reading this excel file and should update the datas in the web app dynamically.
View 1 RepliesI want to give product details in excel sheet but that excel sheet should be zipped and then pass it to user.
I know how to create excel sheet from database but how to pass that excel sheet into folder and then zip that folder..?
i am getting following error while creating the excel file
System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005(E_ACCESSDENIED)). at QA.CreateExcel.createDoc() in e:~~CreateExcel.cs:line 33
i am using this code.
private Office.Excel.Application app =new Office.Excel.Application();
I have a web app where user uploads a file.ile is saved in server locally and I want to read some data from it.Currently my development server has office 2003.So do I need office 2007 in order to be able to read an excel from office 2007 ?
Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook wrkBook; // = new Microsoft.Office.Interop.Excel.Workbook();
Is it possible to upload and Save Excel file as blob in Sql table through web application?
I do not need to query excel file, just be able to upload and download excel file as is.
I want to read write excel file in my application without installing the office on my server. Means my server don't have any excel (MS office) installation. Is it necessory to install the office on server to excute the program of read or write the excel file.
View 5 RepliesIn my project I have to open excel application on click of a button without having ms-excel installed in server and the same case applies to word also. Please suggest me a solutions asap
View 2 Replieshow check installed excel version using excel application in asp.net
I created Excel object Dim oXL As Excel.Application
In the above mentioned article at "[URL]" instead of selecting the existed table in dbserver is it possible to create a dynamic database table based upon the structure of the excel file to be loaded??
View 1 RepliesI have an .xls file that I am allowing a user to make changes to by entering values in TextBoxs within a GridView. In the excel file, there is a column (D) that does a basic (=C4-B4) function. The user is allowed to edit both the B and C columns, but not the one containing the function (D). I am using OleDbCommands to make changes to the .xls file, and that works fine. However, column D is not being updated. I have to physically open the excel file, then save it for the function column to be properly updated. What would be the easiest way to make sure the function is "run" and saved when changes to the source columns are made?
Edit Well, merely hiding the modalpopupextender that it is in saves the file. But I still have the problem of column D not being updated client-side. I assume that's something I'll have to do myself?
i use this code to export data into word.
Protected Sub Export(sender As Object, e As EventArgs) Handles btn_printexcel.Click
Response.Clear()
Response.Buffer = True
[Code]....
but the export docs will be downloaded into the user computer.
what should i do so that the exported docs is save into the server?
I need to auto fit the dropdown width to auto fit with the cell in excel using c#.net.
I have exported the dropdown to the excel using c#.
when the column width of the cell is increated, the width of the dropdown should be auto fit to the width of the cell.
when I used a code of exporting gridview into excel this code worked for a new website which is without masterpage.
my code:
public override void VerifyRenderingInServerForm(Control control) { }
protected void BtnGenerateReport_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition",
"attachment;filename=GridViewExport.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();.....
Now the same code when I copy it in my project having masterpage . there is no compiler error but it is genereating excel file withno data in it but in fact there is data in the grid view at runtime.
I have a page that has a gridview that stores the value of search parameteres in my page.
the search parameters are inserted in a table after the results are exported to excel(done through a seperate button).
Now the problem is once i hit the export to excel button, the gridview is not getting updated. I made sure that the entry is being made in database, but it in is not showing in grid immediately. The grid view is in updatepanel.
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 need to remove the password protection from an uploaded excel file. I have been doing this directly with the Excel assemblies (ASP.NET/C#) and then I tried with the ooxmlcrypto, both worked, but the problem is that I can not deploy either of those solution because of the dependencies.
I mean, my sysadmin does not want us installing Excel on the server and, as I have been searching for some alternatives, I can not find one.
My question is: is there a way to put the necessary dlls in the server without installing Excel or the Office suite?
I found this: Office 2007 Primary Interop Assemblies redistributable package but still, it requires a Microsoft Office Product.
i'm using ASP.NET 3.5 with c#. my problem is that i have created a user control and want to dynamically add mulitple instances of these controls to the web form.when a user adds data to one of the user controls i then need to carry out some calcaulations, change the current user control data and then alter all the other user controls to different values(ignoring the one just changed). i then need to alter some of the controls on the main page outside of any user control.i've no real idea how to do this. i've thought about exposing an event in the user control to pass values up to the page. the page then carries out the processing to non 'user-control' controls then drills down to each user control in turn(all user controls are in a placeholder control). but that would be a pain retrieving all the HTML element id's etc....hope that wasn't abit rambling lol.
View 2 RepliesI'm creating textboxes in the Page_Load event and giving them values, however whenever I load the details I am getting the same output. I always seem to get the first output I got, even on subsequent searches.Here's what my code with the irrelevant information missing:
Textbox txtName = New Textbox();
protected void Page_Load(object sender, EventArgs e)
{
[code]...
If DropDownList has two values (e.g. "Item 1" and "Item 2") and has autopostback enabled, first time it will generate and show "Item 1" in the textbox (the default value for the DropDownList), but if this is changed and the autopostback fires, the textbox does not change.I've tried getting around this by creating a new TextBox, overriding the "LoadPostData" function to prevent this from loading, which got around the issue there, but then I couldn't view the data afterwards.
Any idea how I could get around this? I may be approaching this in the wrong way.Edit: I've added another item to DropDownList that removes TextBox, so that it can be re-created again. It seems to show the correct data when it is re-created after being removed, but if I'm attempting to just edit it, this isn't updating correctly.Edit2: Here's the rest of the code for this page in case this helps at all. The objects which I'm having issues with are SBUName and SBUComments, which are both TextBoxes. The same issue is also happening for SBUClientDropdown but I believe the resolution will be similar:
DBHandler DBHandler = new DBHandler();
List<string> clients = new List<string>();
List<string> clientGroups = new List<string>();
[code]...
I have a Dropdownlist in my form as an example as below.
The Dropdownlist items are pulled out from the database table.
When a user Clicks 'Save Template', A new row is created in the database, BUT the dropdownlist items
remains the same :( I want the list to be dynamic so that the user doesn't have to press F5 for updating the list.
I'm adding items dynamically when a row is selected from GridView.
1. How can i make the items added are selected by default - (solved)
2. How can i avoid duplicates getting added to list
3. How can i remove them from list when user un-checks them.
And I want to change checkbox with an image and I'm using css like following but it is not working
.cbxCustom
{
...
}[code]....
In my project Online Travel Agency, I want that if my employee add a new package in database then newly added package will be shown on package.aspx page dynamically with new tag, so how can i do it.
View 1 RepliesI want to display the text entered in a textbox on a label character by character. I.e, if I enter a character in textbox, I need to display that character in the label. Up to the length of the textbox, this procedure has to done for the label also.
View 3 Repliesusing System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
[Code]....
the row used to get in edit mode only if i edit the next row means first row never get in edited mode.
Hosting page:
protected void Page_Load(object sender, EventArgs e)
{
LoadMyControl(Parameters); //Do it every page load to preserve it's state
}
protected void LoadMyControl(string parameters)
{
plchld.Controls.Clear();
Control userControl = LoadControl("TheUserControl.ascx");
userControl.ID = "userControl1";
plchld.Controls.Add(userControl);
}
Now inside this control, when a button is clicked I want to update ,let's say a Label on the hosting page.
What is the best way to do it? Custom event?
how to change gridview cell value for a checked row without affecting any changes in database for ex if a row contains quantity of item 6 i want to change it value to 5,4 upto 0 that is on click event of delete quantity button i have identified row with a checkbox in grid view.
View 1 Replies