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- Bountied 0
- Unanswered
- Frequent
- Score
- Unanswered (my tags)
#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"); ...- 1
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 ...- 179
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 ...- 179
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 ....- 793
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, ...- 21
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 ...- 13
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.- 13
#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. ...- 1
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 ...- 11
#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 ...- 19
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 ...- 11
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: ...- 1,695
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 ...- 882
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 ...- 11
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) ...- 1
15 30 50 per page12345 Next