Questions tagged [officewriter]

Ask Question

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.

61 questions
0 votes 0 answers 53 views

#officewriter - How to run a macro

I am trying to run a macro with c# in OfficeWriter. I have tried below but does not work. Has anyone done this before? ExcelApplication xla = new ExcelApplication(); xla.RUN("Macro1"); ... Bernie Steiert's user avatar Bernie Steiert
  • 1
1 vote 1 answer 86 views

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 ... Pit J's user avatar Pit J
  • 179
1 vote 0 answers 74 views

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 ... Pit J's user avatar Pit J
  • 179
2 votes 1 answer 1k views

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 .... Mathias Rønnow Nørtoft's user avatar Mathias Rønnow Nørtoft
  • 793
0 votes 1 answer 21 views

Formatting a date column in powerpointwriter

I am using PowerpointWriter to populate a ppt table. I have currency and date columns that need to be formatted (not with colors/fonts/etc). For example, the date column needs to be the date only, ... user1529112's user avatar user1529112
  • 21
1 vote 0 answers 76 views

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 ... Mohan's user avatar Mohan
  • 13
0 votes 1 answer 141 views

How to export SSRS 2008 R2 report(.rdl) to excel with formulas

I want to export SSRS 2008 R2 report (.rdl) to excel with formulas. Is OfficeWriter API has this feature? If yes, can anyone please help me on this? Thanks in adv. Mohan. Mohan's user avatar Mohan
  • 13
0 votes 1 answer 43 views

#officewriter - Worksheet.PopulatedCells.AutoFitHeight(); not working

#officewriter - Worksheet.PopulatedCells.AutoFitHeight(); not working. Recently i have updated excel version from xls to xlsx, but now the above function is not working, giving below error. ... Ramesh's user avatar Ramesh
  • 1
1 vote 0 answers 54 views

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 ... yenyen2792's user avatar yenyen2792
  • 11
0 votes 1 answer 24 views

#officewriter note section is not getting copied while coping slides

I am using below code to add a slide in PPT file at run time: Presentation pres = ppta.Open(@"C:\Users\prabhat.kumar.yadav\Desktop\PPT\ParentPlan.pptx"); DataPrepration dataObject = new ... Prabhat Yadav's user avatar Prabhat Yadav
  • 19
1 vote 1 answer 39 views

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 ... yannispawn's user avatar yannispawn
  • 11
0 votes 0 answers 61 views

how to detect an empty worksheet

I am attempting to use the ExcelWriter class to read the contents of an uploaded Excel file in a way where the code will process the data in any of the workbook's worksheets. So something like this: ... Christopher King's user avatar Christopher King
  • 1,695
0 votes 1 answer 54 views

SoftArtisans: Text Orientation within a Shape

I am attempting to create a diagram using SoftArtisans' ExcelApplication, Anchor and Shape. I am able to get shapes to appear on my output file; however, I have a requirement that the text shown in ... Nick's user avatar Nick
  • 882
0 votes 1 answer 24 views

Is OfficeWritter PowerPointTemplate thread safe?

I am using OfficeWritter to create a PPT file in multiple thread application where I got the error regarding memory. So Can anyone let me know if can use OfficeWriter in multi threaded application. I ... Raj Kushwaha's user avatar Raj Kushwaha
  • 11
0 votes 1 answer 48 views

ExcelWriter data column that is too big for a single cell

i have an ExcelWriter xlsx template that is populated via a datatable. Everything works perfectly but one column in the datatable is too large for the cell. The column is actually varchar(max) ... emil's user avatar emil
  • 1

15 30 50 per page12345

You Might Also Like