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
1
vote
1 answer

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 zeros like 3344. I'm using Office Writer 8.4…
Aruna
  • 1,962
  • 4
  • 25
  • 50
1
vote
2 answers

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 reason. Anyone can advise me on this? And the…
CHOCOx33
  • 25
  • 1
  • 1
  • 7
1
vote
1 answer

Export ado.net dataset into excel worksheets using softartisans Excelwriter

I have a Ado.Net dataset that have three datatables let say Dataset name customer and tables are accounts, purchases and profile . i do like to export them using softartisans ExcelWriter to worksheets using templates Example DataSet myDataSet =…
user2197040
  • 11
  • 1
1
vote
1 answer

OfficeWriter Excel Report - bc30277 Type character '!' does not match

I have an OfficeWriter report that I am trying to publish to SQL Reporting services through Excel. This is a parameterized report with just one input parameter. When I click on 'Publish' in the OfficeWriter toolbar, I get this error message: The…
SoftwareGeek
  • 15,234
  • 19
  • 61
  • 78
0
votes
0 answers

#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"); SoftArtisans.OfficeWriter.ExcelWriter;
Bernie Steiert
  • 1
  • 2
0
votes
1 answer

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, not the time. How do I do this? Thanks, Cheri
user1529112
  • 21
  • 2
0
votes
1 answer

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

#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. Error : No cells have been populated in the Worksheet…
Ramesh
  • 1
0
votes
1 answer

#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 DataPrepration();//Populating Data int noOfChildSlids = 19;//No…
Prabhat Yadav
  • 19
  • 1
0
votes
0 answers

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: foreach (var worksheet in workbook.Worksheets) { …
Christopher King
  • 1,691
  • 23
  • 28
0
votes
1 answer

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 the Shape must read bottom to top, i.e. SHAPE must…
Nick
  • 882
  • 2
  • 9
  • 31
0
votes
1 answer

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 am getting error at when ppt start process:…
Raj Kushwaha
  • 11
0
votes
1 answer

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) populated from text box area in a web application so…
emil
  • 1
0
votes
1 answer

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 added. I've attempted the Excel repair options for…
sohjsolwin
  • 271
  • 1
  • 6
0
votes
1 answer

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 client requires a report with nested groups in an…
Gayatri
  • 1
1
2
3 4 5