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

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
  • 221
  • 4
  • 9
  • 19
0
votes
1 answer

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(); Worksheet WKST = WB.Worksheets[0]; DataSet ds =…
Jay Hoffman
  • 3
  • 1
0
votes
1 answer

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 the reports, the process's memory usage spikes by…
randallkp
  • 33
  • 4
0
votes
0 answers

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 generate dynamic sheets based on DB datasets
user2748021
  • 1
0
votes
1 answer

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. I have tried with openXML but the when password…
user2587034
  • 1
  • 2
0
votes
1 answer

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 error. Error binding in GetColumnNumber at row…
CHOCOx33
  • 25
  • 1
  • 1
  • 7
0
votes
1 answer

{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 index cannot be accessed for the datamarker…
CHOCOx33
  • 25
  • 1
  • 1
  • 7
0
votes
5 answers

How to save the excel output in C# offline?

I have created a simple and basic Hello World template with the sample coding I found in OfficeWriter. However, I want to save the output in a folder inside the computer, not store online (web) The website have already stated how to save to a folder…
CHOCOx33
  • 25
  • 1
  • 1
  • 7
0
votes
1 answer

Issue in Excel writer Reports

Following are the system configurations, • SQL Server 2012 • Office Writer v8.5 • Opening the file in Office 2010 We have been used office writer v3.81 along with SQL Server 2005 in our system. Recently we upgraded our DB and Reporting server to…
Wijitha
  • 1,189
  • 2
  • 12
  • 22
0
votes
2 answers

Softartisans' ExcelWriter v8 bug

The Softartisans' ExcelWriter v8 seems having a bug on merged cell formula. For example: ExcelApplication xla = new ExcelApplication(); Workbook wb = xla.Create(ExcelApplication.FileFormat.Xlsx); area = ws.CreateArea(1, 0, 1, 2); …
user2430837
  • 1
0
votes
1 answer

Populate an excel crosstab

I'm attempting to populate an excel spreadsheet using Softartisans ExcelWriter (part of Office Writer), it fair easy if you need to "load" only one record, or a tabular table. I need to fill a "Crosstab Table", something like this: …
user2300835
  • 1
  • 1
0
votes
2 answers

ExcelSoftArtisans - Bug on Save method with open Stream - Cannot accessed closed file

I have the following issue: I’m doing an export of an ASP.Net GridView directly to an excel file. I’m setting an image as a header in this method: private static void insertPageHeaderFooter(ExcelInterfaceSoftArtisans excel,DateTime…
user2338530
  • 1
  • 1
0
votes
1 answer

Creating Excel document with dynamic header row using OfficeWriter.

I have a requirement to create generic method/ class in C# to generate excel document using Office Writer. In documentation and all samples, it's mentioned to use pre-populated template and fill that template with data. Since I need to create…
RohitKtr
  • 37
  • 1
  • 2
0
votes
1 answer

softartisans excelwriter - How do I get a date style of dd-mm-yyyy hh:mm:ss?

I can either use NumberFormat.DateFormat.MonthDayYearHourMinute24 or NumberFormat.TimeFormat.HourMinuteSecond24 but nothing that will give me the date and the time together along with the seconds :(
Victor Parmar
  • 5,719
  • 6
  • 33
  • 36
-1
votes
2 answers

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 version 6 and they says that older versions are not…
Sonia
  • 11
  • 1
1 2 3
4
5