Hello,

I am trying to create Word document from scratch.  I prepared a asp.net webforms application and got a System DataTable 

How do I insert a table from a datatable using Telerik RadWordsProcessing?

Thank you

First cell of table should not allow wrapping but always does. Does it have anything to do with the fact that I'm using a flow document instead of fixed? There seems to be very little documentation or samples of flow documents.

Hi,

In my MVC project, we used custom-server-side code to export grid data to Excel by utilizing Telerik.Document.SpreadsheedStreaming library.  I explore Processing Document and didn’t find any interface related adding filter  and frozen row to the sheet. Do I have the way to do the job?  Any suggestion will be truly appreciated!  

I am trying to print existing pdfs from a database.    I am working mainly in asp.net expecting the print to happen on the server.  This works for other types of files and I also use Telerik reporting which automatically prints reports on the server.   The problem is what do I use to open an existing pdf and then send it to a printer without user interface.

Hi,

I do HtmlFormatProvider.Import (html), in html have Images, there is an exception (ParamName: data)

(Telerik ASP.NET AJAX 2015.1.104.45)

Why?

I was curious to know the process for simply freezing a specified set of rows at the top.

For example, we have a title section which takes up 7 rows, with each set of cells in a row merged to the number of columns.  The variable colSpan would be the number of header columns in the spreadsheet. 

I simply want to be able to freeze those top rows and be able to scroll both vertically and horizontally through the data below the frozen rows.

However, when I use the freeze panes method, you can scroll vertically through all the content, but the horizontal scrolling starts in the cell at the bottom right of the last title row.  How can I achieve horizontal scrolling beginning at the first row and first cell of the rows below the title rows?

Thank you.

HI,

We used IWorksheetExporter (Telerik.Documents.SpreadsheetStreaming library)  to create Excel file. But did not find any method to create Header and Footer. Does anyone know how to do it? Thanks.

Hello,

When attempting to export a manually created workbook I obtain this error message: 

Value cannot be null.
Parameter name: workbook at Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Utilities.XlsxHelper.ConvertColumnPixelWidthToExcelWidth(Workbook workbook, Double columnWidthInPixels)

   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Contexts.XlsxWorksheetExportContext..ctor(XlsxWorkbookExportContext workbookContext, Worksheet worksheet, Int32 sheetNo)
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Contexts.XlsxWorkbookExportContext.InitializeWorksheetContexts()
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Contexts.XlsxWorkbookExportContext.Initialize()
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.XlsxFormatProvider.ExportOverride(Workbook workbook, Stream output)
   at [Redacted] Controller.cs:line 203

I Generate the workbook using this method:

public Workbook WriteExcelFile(List<Object> list)
        {

            Workbook workbook = new Workbook();
            using (Worksheet worksheet = workbook.Worksheets.Add())
            {
                CellRange range = new CellRange(1, 1, list.Count, 5);
                CellSelection selection = worksheet.Cells[range];

                if (selection.CanInsertOrRemove(range, ShiftType.Right))
                {
                    selection.Insert(InsertShiftType.Right);
                }

                for (int row = 0; row < list.Count; row++)
                {
                    worksheet.Cells[row, 0].SetValue(list[row].string1);
                    worksheet.Cells[row, 1].SetValue(list[row].string2);
                    worksheet.Cells[row, 2].SetValue(list[row].string3);
                    worksheet.Cells[row, 3].SetValue(list[row].string4);
                    worksheet.Cells[row, 4].SetValue(list[row].string5);
               }
            }

            return workbook;
        }

The attempt to write it to a memory stream (FileStream was also attempted)

using (Stream output = new MemoryStream(10000))
      formatProvider.Export(workbook, output);

Could you help me understand the reason behind this error?

I would like to be able to read a PDF document and import the contents of tables within the PDF document.  Do you have an examples that shows how I would:

• Open an existing PDF document
• Read the document line at a time from top to bottom
• Find tables in the document
• Read the cell contents of those tables
  
  ?
  ​

I'm just trying to create a table in PDF with this:

https://docs.telerik.com/devtools/document-processing/libraries/radpdfprocessing/editing/table

In general a nice thing.

1) The only way to set the Font of the (entire) table I found, is to set the Font for each singular block in each singular cell, and this before inserting the text.

That means I cannot just do this: AddTableCell().Blocks.AddBlock().InsertText("cell11");

Is there a simpler way, to have some Default for the entire Table ? I found this DefaultCellProperties thing, but this concerns only background and borders

2) There is this property

table.LayoutType = Telerik.Windows.Documents.Fixed.Model.Editing.Flow.TableLayoutType.FixedWidth;

The automatic works quiet well if you have text in the table, having f.e. an empty line, it shrinks the height of this line.

So I thought I changed to 'fixedwidth' and set it manually.

But than, I haven't found anything to set width oder height of Rows or Cells.

So what is this FixedWidth good for,  how do I set the height of a Row or a ColumnWidth, although the concept of a column is kind of missing in this class.