I want to generate PDF files from Word Documents(.doc, .docx) or excel documents(.xls,.xlsx).
I tried using ITextSharp but with that I am not able to render the images/tables etc of word document into the pdf.
Is there anyway that I can print a file (either word, excel, or pdf) to a network printer using C#? I tried to search around but I haven't find an answer yet
View 6 RepliesI'm working on a web app and need to stream various files. I can do pdfs, images, and older Office documents. However, when I try to do with 2007 documents, it breaks. Here is my code:
Response.Buffer = true;
Response.Clear();
Response.ClearContent();
Response.ClearHeaders();
switch (FileExtension.ToLower())
{
case "pdf":
Response.ContentType = "application/pdf";
break;
case "doc":
Response.ContentType = "application/msword";
break;
case "docx":
Response.ContentType = "application/vnd.ms-word.document.12";
break;
case "xls":
Response.ContentType = "application/vnd.ms-excel";
break;
case "xlsx":
Response.ContentType = "application/vnd.ms-excel.12";
break;
default:
Response.ContentType = "image/jpeg";
break;
}
Response.BinaryWrite(buffer);
The error that I get is:
An invalid character was found in text content. Error processing resource 'http://DomainName/GetFile.aspx.
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 RepliesI have an application I am trying to write that generates a text file conforming to a file specification, and the file could contain thousands of lines. This part is easy. The more challenging part for me is the user interface. It needs to be a web interface with various options to affect what data gets on the file; this part is no problem. The process for generating the file, though, could take a little time depending on the amount of data , and I would think the web page would time out.
What options do I have for the UI? Could I create some sort of service that the page calls and runs in the background? When the process errors or is finished, I'm thinking there could be an email sent out, or even messages displayed on the page.
My requirement is : I have to open a word document in Microsoft word from my web application and the word document is stored in the server location.
In javascript i wrote a code to open the word document like below.
var dsWordApp = new ActiveXObject("Word.Application");
var WordDoc = dsWordApp.Documents.Open(FileName)
Using above script i am able to open the local word doc files but i am unable to open the server side word doc file.
how to open a server side word doc fie in MSword.
I am using asp.net oledb to export information to excel file. I encounter problems when the information to export becomes too big, in this case the code I have given below, the excel file generated becomes an empty spreadsheet. If I changed the loop to 1123 for insertion of the rows. The generated excel file is fine, 1125 rows, and 4 columns shown. A test program in windows form is also working fine regardless of how many rows.
Code has been simplified, "information ..." in the sql insertion command represents 1803 characters.
ExcelObjConn = "Provider=Microsoft.Ace.OLEDB.12.0;" & _
"Data Source=" & fileName & ";Extended Properties=Excel 12.0 XML"
ExcelConnection = New System.Data.OleDb.OleDbConnection(ExcelObjConn)
ExcelConnection.Open()
Try
SqlCommand = "CREATE TABLE ABC ([row1] text, [row2] text, [row3] text, [row4] text)"
ExcelCommand = New OleDb.OleDbCommand(SqlCommand, ExcelConnection)
ExcelCommand.ExecuteNonQuery()
ExcelCommand.Dispose()
For i As Integer = 0 To 1124
SqlCommand = "Insert into ABC ([row1], [row2], [row3], [row4]) Values ('information...', 'information ...', 'information ...', 'information ...')"
ExcelCommand = New OleDb.OleDbCommand(SqlCommand, ExcelConnection)
ExcelCommand.ExecuteNonQuery()
ExcelCommand.Dispose()
Next
Catch ex As Exception
Finally
If ExcelConnection IsNot Nothing Then
ExcelConnection.Close()
ExcelConnection.Dispose()
End If
End Try
I couldn't find a solution to my problem as well. What I did eventually was to run the process using another separate windows service. The code works perfectly fine running from a windows form or service program, but not asp.net, not sure why.
I have created an excel sheet from datatable using function. I want to read the excel sheet programatically using the below connectionstring. This string works fine for all other excel sheets but not for the one i created using the function. I guess it is because of excel version problem.
OleDbConnection conn= new OleDbConnection("Data Source='" + path +"';provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;";);
which i can create an excel sheet such that it is readable again using above query. I cannot use Microsoft InterOp library as it is not supported by my host. I have even changed different encoding formats. Still it doesnt work
[code]....
I need a code which can export the data from XML file to the Excel file.
View 3 RepliesI need to convert a excel file to pdf file in asp.net. How to achieve this in c#.
View 1 RepliesI have to create upload file program and this file should be uploaded in excel file. I do not want to use Pacakage.
View 5 RepliesExcel cannot open the file "Report.xlsx" because the file format or extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file
View 2 Repliesi 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 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 have a MS Word document saved in the web server and I want to open it without MS Office Interop, from my web page.
What is the best possible way to achieve it?
i want to generate the xml file from edm schema for indivual tables data
View 1 RepliesHo to display word file in the browser without downloading.
View 1 RepliesI need to know about print document with asp, the best metod.
I want to send directaly to the printer.
I am sending mails (in asp.net ,c#), having a template in text file (.txt) like below
User Name :<User Name>
Address : <Address>.
I used to replace the words within the angle brackets in the text file using the below code
StreamReader sr;
sr = File.OpenText(HttpContext.Current.Server.MapPath(txt));
copy = sr.ReadToEnd();[code]....
Now I have a new problem,the user will be adding new words within an angle, say for eg, they will be adding <Salary>.
In that case i have to read out and find the word <Salary>.
In other words, I have to find all the words, that are located with the angle brackets (<>).
can some1 teach me how to upload the file (pdf , word) into the database
and able to retrieve the file and read the file at my site .
i already open a folder named pdfword to store my file
and database table named document with document ID and document Name attributes
I have a small web application based on asp.net 2010 that manages invoices.
After the invoice is saved, it should automatically generate a pdf file.
which of the following solutions would be fast and easy to incorporate?
Use Sql Server 2008 Reports
Use Crystal Reports 2008 and Crystal Reports 2008 for VS 2010
Use itextsharp to create the pdf file
Use XSLFO to create the pdf file
The point here is I dont know any of the above. Which one is easy and quick to learn and implement. Are there any other solution to achieve this functionality?
I'm new to c# programming..I'm using windows form application c# .netI have been given a .resources file. it contains 2 columns 1) key and 2) values.I have brought the contents of this file into a datagrid using dynamic table in between and using resource manager.Now i have to edit the value column in the datagrid and if i click on a GENERATE button i should create a new resource file and it has to be stored as a file. In the same way i should create many sucj resource file.
View 1 RepliesI would like to generate a static URL based on a few parameters.The page serve the file for downloading is called CertificateDownload.aspx ,I am generating the download link in Report.aspx.These 2 files reside on the same physical folder.I do not like the replace method ,but I could not think of another way of doing it.How can I improve my code or what is a better way of doing it.
I need the absolute url to be displayed as text in the web browser.
Dim downLoadUrl As String = HttpContext.Current.Request.Url.ToString.Replace("Report.aspx", "CertificateDownload.aspx") + "?CertificateID=" + CertificateName
HyperLinkDownloadLink.Visible = True
HyperLinkDownloadLink.Text = downLoadUrl
HyperLinkDownloadLink.NavigateUrl = downLoadUrl