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
0
votes
1 answer

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 multiple sheets, the sheet names need to be…
Marzipan
  • 13
  • 4
0
votes
1 answer

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 row, I want ExcelWrite just to insert 5 cells and…
Jack H
  • 1
0
votes
1 answer

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 in the workbook that is breaking office writer …
Programnik
  • 1,449
  • 1
  • 9
  • 13
0
votes
1 answer

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 formatting on their own so I'm keeping it light. My…
Nick
  • 882
  • 2
  • 9
  • 31
0
votes
2 answers

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 appreciate any assistance. Thanks.
Alexandre Lefebvre
  • 1
0
votes
1 answer

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 correct (we are using OfficeWriter 8.6.0) Open .rdl…
DeanOC
  • 7,142
  • 6
  • 42
  • 56
0
votes
1 answer

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 contains macros hence I need .xlsm format. Code is as…
user3304711
  • 3
  • 1
0
votes
0 answers

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. Originally I was using a datatable as the source…
Programnik
  • 1,449
  • 1
  • 9
  • 13
0
votes
1 answer

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 shpHeart = shps.CreateShape(ShapeType.TextBox,…
user3270808
  • 1
0
votes
0 answers

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 statement. The template file that I am using is…
user3113086
  • 1
0
votes
2 answers

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
  • 1
0
votes
2 answers

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 easily enough, and that is what the help docs show,…
DeanOC
  • 7,142
  • 6
  • 42
  • 56
0
votes
1 answer

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 create…
uncle_scrooge
  • 409
  • 1
  • 5
  • 28
0
votes
1 answer

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 anyone experienced this before and is there a way…
user2929422
  • 1
0
votes
1 answer

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 application = new ExcelApplication(); Workbook…
user1992449
  • 53
  • 6
1 2
3
4 5