I want create/show/edit a excel file from my asp.net application. All I want is like the working of Google docs. Is there a way I can implement it? Any dll or can i even use the google docs api for that?
View 4 Replies
I have been presented with numerous word and excel docs. The goal is to put them online and bind to a database for the fields and also to store data for easy searching and reporting.
Has anyone done anything like this before?
I know the easy solution would be to create a database table for each particula form and also an ASP.net page for each form.
But then there are problems like printing and correct formating so it fits on the page, spaning multiple pages and so on.
And also is there any advice on how to write to PDF straight from the page?
How can i use the google docs say like wen i display a excel sheet when the user wants to view that particular sheet or document It should open in google docs how can i do that?
View 2 RepliesI'm trying to open Word & Excel docs in a new browser window. The windows opens and then closes straight away. I think I may need browser plugins. Can someone provide some advice on how I can achieve this?
Here's my code:
From calling page:
[Code]....
From new page:
[Code]....
I have to create a text box where if user will enter something it should show the values from database like google shows.e.g If i press a it should display a if i have entered AJ it should show all the list which start from AJ.Same like google.
View 10 RepliesIs that a way to edit excel file on browser and then save it on server?
View 5 RepliesI want to create an Excelfile on the click of a button in C# and when i click the button again it Creates another file with the same name(can add name changed from like Files to Files1) but i dont want to override the previous file.Like if i click button twice there should be two files with small change in the name.
View 1 RepliesOn Previous version of my application, if I want to export my data from SQL Server to Excel 2003 file, I just retrieve data from the SQL server and then straight away show "Open, Save, Cancel" dialog box to get the data on Excel 2003 Format. Here is the existing code in C#.
public void ExportToExcel(string StrFileName, DataTable dt)
{
if (dt!= null && dt.Rows.Count > 0)[code]....
but when I want to Export to Excel 2007 format with the same. I don't have any Idea to export it.
I 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 have an Excel file called Products.xls .I have Columns A and B, with the titles NAME and QUANTITY.The name of the sheet is SHEET1.The file has about 40 lines.How do i show these data on a Gridview or Listview ?
View 4 RepliesI am creating excel file using XML. I need to add a logo image in the excel file.
[Code]....
How can we add the picture, I need to show when users open in the page.
I am uploading an Excel file into DataSet/Gridview but once the file is uploaded, then i want to be able to make changes the data that is uploaded like making changes the data inside the Gridview or deleting the data etc. Here is my code:
<div>
<asp:FileUpload ID="FileUpload1" runat="server" />
<asp:Button ID="btnUpload" runat="server" Text="Upload" OnClick="btnUpload_Click" />
<br />
[Code].....
I need to create a .XLS file and put it available for download in my .aspx page. this file is needed to have information from database. I'm using Linq to SQL. So I need a C# code for reading from DataBase using Linq and create a .XLS file for download.
View 1 Repliesi want create a file excel from sql server? how can i do?
and can i create it using also sqldatasource control?
When I click the Edit button in Gridview twice it'll always show the edit box or (textbox in gridview are editable)how to prevent that?
View 4 Replieswhen 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 used file upload on one of my web page..the file path is not shown in google chrome..rest in all browser the path is shown..in google chrome only the file name is shown and not the whole path..i want the path to be shown in google chrome
View 1 RepliesI have a web-report listing links to pdf documents. The pdf docs shows up in a new page based on frames in frames. I do not have control on the page showing pdfs.
In the web-report I want to let the user select multiple docs and then send them to print on the client.
I'm trying to create an interface similar to google's search box.
When you type a search string into the box, the drop panel appears suggesting all matches to the search as it's being typed.
Anyone know how do we do this with ASP.net?
How I can to Create a dynamic Google SiteMap in ASP.NET 2 or higher??
now I can to Create Static dynamic Google SiteMap.
how to create dynamic google sitemap from my database?
View 4 Repliesi want to show address on google map in my website..i searched more but i find third part google map dll..
i don,t want to add third party Google map DLL in my website.
I was looking for a solution on how to create a static google map by passing longitude and latitude value through database. What I want to do is to create a static image as PDF conversion requires static image. Thats why I want a static image so that I can convert aspx page into pdf and then email that map to the customer.
View 2 RepliesI'm looking for a library/component able to edit a .dwg file (Autocad file) in a ASP.NET page? I just need to make some minor changes in a .dwg file?
View 1 Repliesi have try to export data to excel using gridview.
I have export it successfully but some data is missing which is due to the column format in the exported excel file is not TEXT .
[Code]....
I need to set the exported excel file column format to TEXT but find no solution on this.
