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.

officewriter
Filter by
Sorted by
Tagged with
0 votes
0 answers
55 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
1 vote
1 answer
89 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
  • 179
1 vote
0 answers
76 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
  • 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
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
1 vote
0 answers
77 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
  • 13
0 votes
1 answer
144 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
  • 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
  • 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
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
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
0 votes
0 answers
62 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
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
  • 880
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
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
  • 1
0 votes
1 answer
241 views

SoftArtisans ExcelWriter returning duplicate key error when attempting to open xlsx file

We are using the SoftArtisans ExcelWriter to open and process data from various excel files. One file has recently begun giving us the following error: An item with the same key has already been ...
sohjsolwin's user avatar
1 vote
0 answers
106 views

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 ...
DeanOC's user avatar
  • 7,202
5 votes
0 answers
154 views

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” “...
shiego926's user avatar
1 vote
1 answer
228 views

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 ...
Ningraj's user avatar
  • 21
0 votes
1 answer
402 views

Can officewriter help to resolve SSRS excel export(with merged cells) row-height issue

I am evaluating Office writer for the following problem that we are facing with SSRS excel export. Could someone advise how can we use OfficeWriter to resolve this issue. Problem Statement : Our ...
Gayatri's user avatar
0 votes
1 answer
61 views

OfficeWriter data marker for sheet name

We only have the Template DLL v.8 installed, we use Microsoft SSIS v.2008R2 to process the data and then use a script task to bind the data to a template. I have a need to produce a workbook with ...
Marzipan's user avatar
0 votes
1 answer
136 views

Soft artisans ExcelWriter Data Binding - Insert Cells Instead of Rows

According to the article http://wiki.softartisans.com/display/EW8/How+ExcelWriter+Inserts+Rows ExcelWriter inserts a new row for every row in the dataset. What if my dataset has 5 columns, for each ...
Jack H's user avatar
  • 1
0 votes
1 answer
106 views

Soft artisans excel writer cannot cope with large workbook

I am trying to open a workbook and loop through each sheet using office writer - the workbook has over 30 sheets, but the office writer workbook object thinks there are only 6. There something weird ...
Programnik's user avatar
  • 1,487
-1 votes
2 answers
348 views

upgrading from ExcelWriter version 5

I maintain an old application in C# who use ExcelWriter version 5. Next year we'll update to 64bits and I was searching about any documentation of this upgrade. I've only searched upgrading from ...
Sonia's user avatar
  • 11
2 votes
1 answer
88 views

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 ...
Wijitha's user avatar
  • 1,289
1 vote
1 answer
105 views

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 ...
Dave3868316's user avatar
0 votes
1 answer
65 views

Cell Alignment using ExcelApplication

I am using ExcelApplication, not ExcelTemplate - so I'm programmatically doing a slight bit of formatting so it's just a super plain excel sheet - however, I presume my end-user would like to do ...
Nick's user avatar
  • 880
0 votes
2 answers
71 views

WordWritter WordTemplate - How to remove a section when data is null?

I'm using the WordTemplate from softartisans to generate a report. Some part of the report may not have data. How do I remove a section from the generated Word document when the data is null? I would ...
Alexandre Lefebvre's user avatar
0 votes
1 answer
278 views

Editing an OfficeWriter rdl in VS2008 loses format

Our scenario is that we have been given a Word document that needs to be turned into an SSRS report. So our steps have been: Open document in Word 2007 Save document as .rdl after getting layout ...
DeanOC's user avatar
  • 7,202
0 votes
1 answer
261 views

Softartisan Officewriter does not create excel format with .xlsm extension

I want to create new excel sheet with .xlsm extension by using softartisan dll, however in create method of softartisan does not have xlsm format. It has only .xls and .xlsx formats. My new excel ...
user3304711's user avatar
0 votes
0 answers
219 views

Out of memory exception in Soft Artisans Excel Writer

I am using Soft Artisans Excel Writer to populate an excel template via binding. When my data source (data reader) exceeds about 120000 rows I get an "Out of Memory" exception from excel writer. ...
Programnik's user avatar
  • 1,487
0 votes
1 answer
345 views

How to mimic watermark in excel using softartisans ExcelWriter? If so do we have any sample code for it?

Sample Code: ExcelApplication xla = new ExcelApplication(); Workbook wb = xla.Create(); Worksheet ws = wb.Worksheets[0]; Shapes shps = ws.Shapes; Anchor anch = ws.CreateAnchor(0, 7, 0, 0); Shape ...
user3270808's user avatar
1 vote
3 answers
1k views

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 ...
Isaac_Zhu's user avatar
  • 105
0 votes
0 answers
161 views

For each loop on ExcelWriter.Worksheets takes excessively long to process - Any workaround?

The problem that I am experiencing is that the For Each ws In xlWorkbook_.Worksheets statement is taking excessively long to process. With only 7 worksheets it is taking 23 seconds to process the one ...
user3113086's user avatar
0 votes
2 answers
185 views

Change Text Color within a cell using OfficeWriter Excel

I am trying to change the font color for specific words with-in a cell. I don't want to change all of the text to the color just specific words. I am using an OfficeWriter ExcelTemplate.
user2929422's user avatar
0 votes
2 answers
193 views

Can I create a non-pie chart using Excelwriter and SSRS Integration?

I'm using SoftArtisans ExcelWriter for SSRS (ver 8.6), and am wondering if it is possible to create a (non-pie) chart, e.g. a Stacked Bar chart, that has multiple series? I can create pie charts ...
DeanOC's user avatar
  • 7,202
0 votes
1 answer
485 views

Cannot create object in classic asp

I have softartisans office writer version 8 and also installed excel viewer.I want to open excel by my application which is developed in classic asp and vb.So when i run application it says "cant ...
uncle_scrooge's user avatar
0 votes
1 answer
237 views

Hidden Cells still showing in an OfficeWriter Excel Spreadsheet

When my Office Writer Excel report opens, it randomly un-hides some of the hidden cells and columns. I have verified that it is not the data that causes the columns or cells to not be hidden. Has ...
user2929422's user avatar
0 votes
1 answer
1k views

How to convert Excel 2007 Open XML (*.xlsx) to legacy format files (*.xls, ex. Excel 97) using Softartisans ExcelWriter

Is there a way to convert between the new Excel 2007/2010/2013 (.xlsx) file format and the old pre-2007 (.xls) format using the Softartisans ExcelWriter .NET library. This code: ExcelApplication ...
user1992449's user avatar
0 votes
1 answer
98 views

Is cell locking is possible in excel using officewriter?

I need to lock a particular cell value in an Excel file using OfficeWriter. Is this possible? If so, what API calls do I need to use?
Prabakaran's user avatar
1 vote
3 answers
4k views

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?...
GeekzSG's user avatar
  • 953
0 votes
1 answer
663 views

ExcelWriter.Style CellLocked - why won't it work?

I'm trying to create a simple example with #officewriter #excelwriter and having trouble using the styles. Not sure why. ExcelApplication XLAPP = new ExcelApplication(); Workbook WB = XLAPP.Create();...
Jay Hoffman's user avatar
0 votes
1 answer
624 views

Classic ASP & SoftArtisans ExcelWriter Memory Issue

I'm using ExcelWriter (SAExcel.dll version 1.1.0.0) in Classic ASP (I know it's an ancient configuration) to generate some pretty hefty reports (~12,000 rows of 50 cells at the most). When generating ...
randallkp's user avatar
0 votes
0 answers
129 views

Dispose SoftArtisans ExcelWriter objects from memory? It shows Memory Out Of Exception

While generating excelsheets , i am able to generate 5 sheets at run time , but on the 6th sheet , the memory consumption hits till 2.8GB , and it crashes out. I am using C# .net with OW API to ...
user2748021's user avatar
0 votes
1 answer
298 views

Password protected excel

can we create password protected excel workbook or sheet with 'Officewriter' API? My requirement is to create pwd protected excel programatically (c#) with out having to install office in the servers. ...
user2587034's user avatar
-1 votes
1 answer
796 views

How to extract certain cell from DataTable and retrieve the value to be used in console application

I want to retrieve some value from the dtSource and dtDestination before using it. But it seems that I cannot retrieve any value inside even though there is some values stored inside the database. Is ...
CHOCOx33's user avatar
0 votes
1 answer
154 views

Error binding in GetColumnNumber at row 1

I got this OfficeWriter error when debugging the console application. I used methods to retrieve config details for the database used in the coding from the master database, and ended up having this ...
CHOCOx33's user avatar
0 votes
1 answer
323 views

{Updated} OfficeWriter error: the datasource binding name must be unique

[SOLVED] Faced this error when debugging, the error goes like this: Error attempting to interpret or access data field for the GetColumnNumber(Name) in row 0 of this data source This field name or ...
CHOCOx33's user avatar
1 vote
1 answer
264 views

Excel Text formatting does not applying in Office writer reports

I'm using office writer reports to export data to excel. In that I have some reference number field which is 00033444. I have set the cell formatting to "text". But it still displays without leading ...
Aruna's user avatar
  • 2,012
1 vote
2 answers
10k views

Error: Configuration system failed to initialize

Used console application and I have a problem on the app.config file. By right, the code should be correct according to the various sources found in the Internet but my coding is not working for no ...
CHOCOx33's user avatar