Questions on Telerik Document Processing Forum

2 answers

965 views

Report / DocProcessing / Word Template ??

I have a report that is currently generated by hand. It is a 4 page report that is done by hand in Word. Each page has text, images and dynamic data (some of which is inside paragraphs of text, bullet lists etc. On page 4 is a data table. I am trying to figure out the best approach to automate this report. Should I use a Telerik Report, DocProcessing to generate it (which seems tedious with a RadFixedDocument), a word or html template?? Any suggestions?

General Discussions

answered on 22 May 2017

1 answer

488 views

How to tell how big zip file will be

Hi,

I have a situation where I need to send a fairly large amount of data via zip files by email.

The company server limits emails to 4 mg in size, so I can't send one big zip file that, for example, might be 10mg.

I need to:

1. create a zip file

2. add a file to it

3. test how big the zip file is.

4. if it's larger than 4 mg, back out the file I just added use the< 4mg file to attach to the email.

5. Lather, rinse, repeat until all files have been sent.

How do I tell what the current size of the zip file will be after adding a file to it but before I close the archive?

01.MailMessage mail;

02.long currentZipSize = 0;

03.int attIdx = 0;

04.// Get the selected attachments

05.var q = from a in db.Attachments

06. where rptParms.AttachmentIds.Contains(a.AttachmentId)

07. select a;

08.List<Models.Attachment> lstSel = q.ToList();

09.int i;

10.mail = new MailMessage();

11.using (MemoryStream ms = new MemoryStream())

12.{

13.using (ZipArchive zArchive = new ZipArchive(ms, ZipArchiveMode.Create, true))

14.{

15. var lrEntry = zArchive.CreateEntry("LabReport.pdf", CompressionLevel.Fastest);

16. using (BinaryWriter bw = new BinaryWriter(lrEntry.Open()))

17. {

18. bw.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);

19. bw.Flush();

20. }

21. currentZipSize = zArchive.GetSize; // ************* how do I get this size?

22. Models.Attachment att1;

23.

24. // Add them to teh zip

25. for(i = attIdx; i < lstSel.Count; i++)

26. {

27. att1 = lstSel[i];

28. ZipArchiveEntry zEntry = zArchive.CreateEntry(att1.FileName, CompressionLevel.Fastest);

29. using (var f = File.Open(att1.FullPathDecorated, FileMode.Open))

30. {

31. using (Stream entryStream = zEntry.Open())

32. {

33. f.CopyTo(entryStream);

34.// ************* how do I get this size? when I run this I get an error

35.// *************

36. currentZipSize += zEntry.CompressedLength;

37. }

38. // if the size is too big for the mail server back out the last file

39. if (currentZipSize > 4000000)

40. {

41. currentZipSize -= zEntry.CompressedLength;

42. zArchive.GetEntry(att1.FileName).Delete();

43.

44. ms.Seek(currentZipSize, SeekOrigin.Begin);

45. SendMail(mail, rptParms, ms, zArchive, af.CustomKey, emailCnt++);

46. currentZipSize = 0;

47. attIdx--;

48. }

49. else

50. attIdx++;

51. }

52. }

53.

54.

55.}

56.//byte[] buf = ms.GetBuffer();

57.//Buffer.BlockCopy(buf, numberOfBytesToRemove, buf, 0, (int)ms.Length - numberOfBytesToRemove);

58.//ms.SetLength(ms.Length - numberOfBytesToRemove);

59.//ms.Seek(0, SeekOrigin.Begin);

60.//System.Net.Mail.Attachment oAttach = new System.Net.Mail.Attachment(ms, "LabReport.zip");

61.//mail.Attachments.Add(oAttach);

62.//SmtpClient client = new SmtpClient();

63.//client.Host = "intermail.basf-corp.com";

64.//client.Send(mail);

65.//client.Dispose();

66.//mail.Dispose();

67.Utilities.SetStatusBarText(EventAggregator, "Report Sent.");

68.}

ZipLibrary

answered on 22 May 2017

1 answer

148 views

Protection of a Document on exporting to docx

Hello,

I want to protect some Paragraphs in a document against changing. But it seems not to be possible.

I have tried:

document.ProtectionSettings.Enforce = true;
document.ProtectionSettings.ProtectionMode = DocumentProtectionMode.ReadOnly;

But it ist still possible to Change the document in word.

Thanks in advance

Holger

WordsProcessing

answered on 10 May 2017

1 answer

260 views

Y position of the bottom of dynamically created elements

I'm struggling to see how to programmatically keep track of the relevant Y position to give to the FixedContentEditor after adding dynamically created elements such as tables and Text that can vary in height.

An example would be Drawing a Block that contains text from a SQL Query. This text could be one line long or 30 lines long and therefore the height of the text can vary greatly (below its in dtJobHeader.Rows(0).Item("Comment")). I need to be able to tell the editor.position.translate where it needs to move to and draw the next block after the previous block is drawn.

editor.Position.Translate(defaultLeftIndent, currentTopOffset)
editor.DrawBlock(DrawBlock(dtJobHeader.Rows(0).Item("Comment")), New Size(maxWidth, Double.PositiveInfinity))

currentTopOffset += ????
editor.Position.Translate(defaultLeftIndent, currentTopOffset)
editor.DrawBlock(DrawBlock("Some Text Here, etc, etc, etc"), New Size(maxWidth, Double.PositiveInfinity))

Private Function DrawBlock(texttodraw As String) As Block

Dim block As New Block()
block.GraphicProperties.FillColor = RgbColors.Black
block.HorizontalAlignment = HorizontalAlignment.Left
block.TextProperties.Font = FontsRepository.Helvetica
block.InsertText(texttodraw)

Return block

End Function

PdfProcessing

answered on 09 May 2017

4 answers

758 views

Convert Docx to pdf

Hi,

Is it possible to do the DOCX to PDF conversion? Because I have a document in a folder and I want to export to pdf.

PdfProcessing

answered on 09 May 2017

3 answers

734 views

Cell vertical aligment

How to align content in cell vertically?

cell.VerticalAlignment = Telerik.Windows.Documents.Flow.Model.Styles.VerticalAlignment.Center;

does not help me. Text is still align at top

cell = row.Cells.AddTableCell();

cell.VerticalAlignment = Telerik.Windows.Documents.Flow.Model.Styles.VerticalAlignment.Center;

cell.PreferredWidth = new TableWidthUnit(TableWidthUnitType.Percent, 15);

paragraph = cell.Blocks.AddParagraph();

run = paragraph.Inlines.AddRun();

run.Text = "Text in cell text in cell text in cell";

WordsProcessing

answered on 05 May 2017

1 answer

340 views

VB.net version of Create Table Example

I'm trying to create a table and add strings to the cells in a RadFixedDocument as per the c# example here:

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

table table = new Table();
TableRow row = table.Rows.AddTableRow();
row.Cells.AddTableCell().Blocks.AddBlock().InsertText("First cell");
row.Cells.AddTableCell().Blocks.AddBlock().InsertText("Second cell");

When I convert this to vb.net using your tool I get this:

Dim table As Telerik.Windows.Documents.Flow.Model.Table
Dim row As Telerik.Windows.Documents.Flow.Model.TableRow = table.Rows.AddTableRow()
row.Cells.AddTableCell().Blocks.AddBlock().InsertText("First cell")
row.Cells.AddTableCell().Blocks.AddBlock().InsertText("Second cell")

and get the following error:

AddBlock is not a member of BlockCollection

Could someone please attached a code snippet or demo showing how to create a PDF containing Tables with values in them but in VB.NET please.

(I am doing this in a AJAX web application Telerik R1 2017)

PdfProcessing

answered on 03 May 2017

6 answers

670 views

No Wrap Equivalent?

I do not know what the data going into the PDF will look like - and would like to be able to set Number and Date cells/columns to not wrap by default. Is this possible?

PdfProcessing

answered on 03 May 2017

7 answers

731 views

Header/Footer not imported from DOCX

I am importing a DOCX but the header and footer is not appearing when exporting to PDF. Any ideas?

WordsProcessing

answered on 26 Apr 2017

4 answers

266 views

Error: Windows cannot complete the extration. The destination file could not be create.

The dynamic Word documents was created in ASP.net and stream it through System.IO.MemoryStream.

I read the stream data from System.IO.MemoryStream and put it in a Zip file using Telerik Zip Archive Entry,

But the error of "The destination file could not be create" keeps popping out...please see my code below and

let me know what I missed....Please help me....thanks.

oResponse.Clear()
oResponse.AddHeader("content-disposition", "attachment; filename=Gerrytest4.zip")
oResponse.ContentType = "application/octet-stream"
Using memoryStream As New System.IO.MemoryStream
       Using archive As New ZipArchive(memoryStream, ZipArchiveMode.Create, True, Nothing)
              Using entry As ZipArchiveEntry = archive.CreateEntry(sSSPFilename)
                     Dim writer As New BinaryWriter(entry.Open())
                     oDocTemplate.Save(memoryStream, oFormat)
                     Dim sr As BinaryReader = New BinaryReader(memoryStream, System.Text.Encoding.UTF8)
                     memoryStream.Position = 0
                     writer.Write(sr.ReadBytes(memoryStream.Length))
                     writer.Flush()
             End Using
       End Using
      oResponse.BinaryWrite(memoryStream.ToArray())

End Using

ZipLibrary

answered on 24 Apr 2017