I'm using the Aspose library to create an Excel document. Somewhere in some cell I need to insert a new line between two parts of the text. I tried "\r\n" but it doesn't work, just displays two square symbols in cell. I can however press Alt+Enter to create a new line in that same cell. How do I insert a new line programmatically? ...
Does anyone know how to simply open and close an Excel workbook? I don't need to read any data from the file, I just need to open and close it. (*) I'm guessing that I'll need to reference the Microsoft.Office.Interop.Excel assembly. *Reason: I've already configured pivot table information with a 3rd party library (Aspose). Now I ne...
I'm using Aspose.Cells to build an Excel document programmatically. This works great. One of the cells, though, is a block of raw HTML. I'm wondering if it is possible to tell Excel (in any fashion, including the GUI - you don't need to know the Aspose API) to parse and display a cell as HTML. Right now, it just shows up as the raw HTML ...
Given the following code: using Aspose.Cells // {...} Workbook workbook = new Workbook(); Worksheet virtualWorksheet = workbook.Worksheets[0]; virtualWorksheet.Cells[0, 0].Formula ="=1<2"; How do I evaluate the formula in Cell [0,0]? bool isCellTrue = virtualWorksheet.Cells[0, 0].BoolValue; // will generate an exception at run-...
I am appending some text containing '\r\n' into a word document at run-time. But when I see the word document, they are replaced with small square boxes :-( I tried replacing them with System.Environment.NewLine but still I see these small boxes. Any idea? ...
Hi, I'm creating a newspaper authoring system. Today I'm using Aspose.Words library to generate newspaper using Docx format as output, based on a lot of other documents as input. The basic idea is to load a lot of articles documents into a List, then generate a final docx with newspaper. We need to get the total height of a text (with...
I'm using Aspose to handle PDFs and Word documents. Each time I'm about to do something with a document, I make sure to call this: Aspose.Pdf.License pdfLicense = new Aspose.Pdf.License(); pdfLicense.SetLicense("Aspose.Total.lic"); Aspose.Words.License wordLicense = new Aspose.Words.License(); wordLicense.SetLicense("Aspose.Total.lic")...
Hi, I am looking for .NET component to convert different files into PDF format. Right now I need to be able to convert programmatically doc, xls and TIFF files to PDF. But I may need to deal with more file types in near future. I looked at Aspose.Words, it works good but for doc only. Is there any component on the market that would all...
I am trying to use Aspose.Words library through COM Interop. There is one critical problem: I cannot set color. It is supposed to work by assigning to DocumentBuilder.Font.Color, but when I try to do it I get OLE error 0x80131509. My problem is pretty much like this one. update: Code Sample: from win32com.client import Dispatch Doc = ...
On my ongoing saga to mirror the hosting of a legacy app on a clean box, I've hit my next snag. One page relies on a big .NET UserControl that on the new machine renders only as a big, greyed out textarea (greyed out vertical scrollbar on the right hand edge. Inspecting the source shows the expected object tag.) This is particularly tri...
Converting html-page to image or xps without lost css style. var document = new Document(input, LoadFormat.Html, null); document.Save(output, SaveFormat.Xps); Do you have any idea? May be anything library? ...
Hi, I am using Aspose for reading a powerpoint as a tempate and creating a new powerpoint as a report. In the template power point I read the chart and populate the data for the chart. But in the report powerpoint, thechart is fuzzy and is not very clear. But when I edit the chart and save it( I donot change any values or properties )...
Does anyone know how to handle powerpoint 2010 files with aspose.slide library? When i create an instance of powerpoint, it gives me error that i am referring to zip file. ...