Stack Overflow
Stack Overflow

Questions tagged [officewriter]

The OfficeWriter API is a .NET library that allows you to generate, manipulate, and read Excel and Word documents from your own applications without the need to have Microsoft Office installed. It has native integration with SSRS and SharePoint.

The OfficeWriter API is a .NET library that allows you to generate, manipulate, and read Excel and Word documents from your own applications without the need to have Microsoft Office installed. It has native integration with SSRS and SharePoint.

More information

61 questions
5
votes
0 answers

Why does WordWriter's Repeat-block in an IF statement does not render a document successfully?

While working on a word template, there was a need to put repeat blocks in an IF field, similar to this: WordTemplate sample code using .DOC/.DOCX: { IF {MERGEFIELD DataSource1.FieldName}=”123456” “IF SECTION Then a repeat block here using a table…
shiego926
  • 51
  • 3
2
votes
1 answer

Could not load type 'System.Data.OleDb.OleDbType' from assembly officewriter.proces()

When i am trying to populate merge fields in a document template, when i reach the wordTemplate.process(); it tries to load a type 'System.Data.OleDb.OleDbType', but none is found. The project is a .net framework 4.7.2 class lib with a .net Core 2.1…
Mathias Rønnow Nørtoft
  • 783
  • 9
  • 27
2
votes
1 answer

Install officewriter for two instances of reporting server on a single machine

We have installed two instance of the MS report server (2012) on the same machine for two instances of the same application. There are some reports that have created using OfficeWriter. For them to work, we need to install office writer. When…
Wijitha
  • 1,189
  • 2
  • 12
  • 22
2
votes
2 answers

After I bind a DataTable to an Excel template sheet, how can I build an Excel scatter chart on top of the DataTable placeholders?

Here my problem in short. I'm using a demo version of OfficeWriter to figure out whether it is suitable for our porpuses or not. In particular i've prepared an Excel template composed of 8 placeholders, representing the X-Y columns of 4 DataTables,…
user2324645
  • 23
  • 4
1
vote
1 answer

SoftArtisans library and Excel 97 compatibility vs 1048576 limit rows bug report

SoftArtisans trigger run-time exception in regards of 65536 max rows. The most strange is I use Office 2016 which have 1 048 576 max rows. I am now using Office 2016 which have max cell rows count equal to 1 048 576. When I use your library it seems…
Pit J
  • 169
  • 8
1
vote
0 answers

SoftArtisans Error: Unable to parse formula: Unable to find function 'IFERROR' in function table

Well, this is perfectly work on all version of excel. Except SoftArtisans library which I use. I do not want to buy new version. I just want update to this bug only. Advance information was send by mail to support also. Here some intro Error: …
Pit J
  • 169
  • 8
1
vote
0 answers

How to export SSRS report (.rdl) directly to PDF with OfficeWriter

I want to export a SSRS 2008 R2 (.rdl) report directly to PDF, how can i do this with OfficeWriter? I have gone through SoftArtisans documentation, i couldn't find a way out there. We can export an excel file to PDF but i want to export rdl directly…
Mohan
  • 13
  • 2
1
vote
0 answers

Stored Procedure is not accepting values with ' and ò

I have a problem with my SQL Stored Procedure when special characters are input. For example in my Home Country Filter, I have input "Còte D'Ivoire", and I cannot generate a Report/Result because of the "'" and "ò". Error: There were invalid…
yenyen2792
  • 11
  • 2
1
vote
1 answer

Relink SSRS report to Officewriter template

We have some SSRS reports with several tabs which have been developed in SoftArtisans Officewriter as well. We had some consultants make changes to the reports and they redeployed them without touching the Officewriter portion, thus overwriting.…
yannispawn
  • 11
  • 3
1
vote
0 answers

Cannot dynamically insert image into Word document

We are using OfficeWriter 8.6.0 with SSRS 2008 R2 to generate Word documents from .rdl's. The Word docs being generated are in Office 2003 format (.doc) The .rdl's were created in VS2008, and then edited in Word via the OfficeWriter add-in. The…
DeanOC
  • 7,142
  • 6
  • 42
  • 56
1
vote
1 answer

SoftArtisans.OfficeWriter.Shared.SARuntimeException: Cannot have a hidden Worksheet selected

I am using softarisans officewriter in my web API. I am trying to copy sheet data from source excel file to destination excel file. I am facing the above error when saving the destination excel. I have added the piece of code for reference. Any help…
Ningraj
  • 21
  • 4
1
vote
1 answer

How to automatically create new worksheet when data exceeds 65536 rows when exporting using OfficeWriter?

I have a report that exceeds 65536 rows of data. From my understanding, correct me if I'm wrong here, Officewriter template can only render this much data (65536), and the remaining rows will be removed. Is there any way to automatically create a…
Dave3868316
  • 13
  • 3
1
vote
1 answer

Debugging report error on SSRS

we have a bunch of reports (RDL) on SSRS built using officewriter. Sometimes errors occur in a report after updating the excel template. While the report renders fine, an error occurs on the server when trying to save the report using 'export to…
SoftwareGeek
  • 15,234
  • 19
  • 61
  • 78
1
vote
3 answers

How to set a Excel cell's value type to Text in C#?

I'm using Softartisans OfficeWriter to generate Excel files. The problem I have is that whenver I assign an empty string ("" or String.Empty) to a cell, the cell's value type will turn out to be Blank instead of Text, which is what I want. I've…
Isaac_Zhu
  • 105
  • 10
1
vote
3 answers

Save the output as PDF file

We are currently using SoftArtisans to generate Excel and Word files. We need to extend this to also create PDF files. Does OfficeWriter currently support this? If not, any plans to add this feature? Or any opensource library that can be used to…
GeekzSG
  • 943
  • 1
  • 11
  • 28
1
2 3 4 5