Stack Overflow
Stack Overflow

Questions tagged [smartxls]

18 questions
2
votes
2 answers

Aspose.Cells vs SmartXLS

Has anybody used/evaluated both of these libraries and can tell me the difference? Otherwise has anyone here used SmartXLS for reading/creating/updating excel files and can tell me his experience? The later is considerably cheaper than the former.
michaelr524
  • 871
  • 2
  • 11
  • 21
2
votes
1 answer

Reading xlsx file using SmartXLS

Can anybody please tell me how to use SmartXLS to read xlsx file by giving an example?
Supereme
  • 2,379
  • 12
  • 46
  • 67
2
votes
1 answer

Design API for Create Pivot in Excel Using Java

I am Java Developer and I want to design Java API for creating a Pivot Table in Excel. However, I am stuck how would I create one? Does anybody have an idea about how to design Java API for creating a Pivot Table in Excel. I am familiar with POI,…
Ashu-Goel
  • 31
  • 1
  • 6
1
vote
1 answer

Change Sheet in Excelfile using SmartXls

I´m using SmartXLS for Java(5.7.1) to do some calculations in Excel. Does anyone have experience with SmartXLS? There are 5 worksheets in my file and I want to edit sheet 2. How am I able to select a specific sheet or how can I select a specific…
Hubi
  • 440
  • 1
  • 11
  • 25
1
vote
0 answers

Convert excel file from XLSX to XLSB in Java

I am using Java + Apache POI to generate an excel file (format xlsx/xls). Due to huge data the generated excel file (format xlsx/xls) takes more size (~50 MB). So I am trying to convert xlsx/xls to xlsb to reduce the size of the excel file. Here…
Parthiban
  • 105
  • 4
  • 16
1
vote
1 answer

How to read a Date column from excel to a string in c#?

I am writing a C# console application which reads data from Excel spreadsheet using the SmartXLS library. I am able to read all the other column data except the 'usage date'column. Kindly, suggest me a way to solve this problem. Date column in…
Rev4
  • 45
  • 1
  • 11
1
vote
1 answer

Using smartxls dll I cannot change the default name on open

I am using smartxls in my asp.net project with c#. I have the following code: var excel = new SmartXLS.WorkBook(); string projPath = AppDomain.CurrentDomain.BaseDirectory; excel.readXLSX(projPath + @"ExcelTemplates\" +…
Christina O
  • 11
  • 2
1
vote
1 answer

Formula address from column and row numbers in SmartXLS (java)

How can I get the formula address of a cell knowing the column and the row numbers? I want to use it to link a dynamic data source to a chart. THX
NightFox
  • 57
  • 1
  • 6
0
votes
1 answer

How I can export xlsx using SmartXLS

I need export the excel output, after edit using this library. tips??
JBreloaD
  • 1
  • 1
0
votes
1 answer

Thread Locking issue with SmartXLS

WE have been seeing issue with SmartXLS when we run it with multi threaded environment, does anyone have seen issue? we are using java 1.7 SmartXLS 4.6 java.lang.Thread.State: BLOCKED at com.smartxls.a.aj.a(SourceFile:44) - waiting to…
Umer
  • 15
  • 1
  • 5
0
votes
1 answer

Is there way to manipulate entire row (or column) of data using SmartXLS

I have looked at their documentation and noticed that there are not many ways to manipulate entire rows or columns. They provide ways to manipulate range of data but not the whole. I have been checking out http://www.smartxls.com/sample-list.htm but…
Shintaro Takechi
  • 1,215
  • 1
  • 17
  • 39
0
votes
1 answer

smartXLS - sheetRangeToImage not working

I have this problem using smartXLS library for Java I try to export the sheets of a workbook as .png images using the method workbook.sheetRangeToImage(row1,col1,row2,col2,file) The code I use is as follows: private static void takeValuePics()…
pantso14
  • 1
  • 1
0
votes
0 answers

Get Cells position with SmartXLS workbook

I'm using SmartXLS workbook to read an excel file, I can access to the data at index like :: var workbook = new WorkBook(); workbook.read(filePath); //read from Excel File var dataTable =…
Blue Cross
  • 73
  • 12
0
votes
1 answer

Import modified data in Excel to Database Table

I'm working on the function Import, i have an excel file which contains some data, that later will be edited by the user, I managed to do the import excel by SmartXLS in C# and update all data to SQL Server Database, however, what I did is to fetch…
Blue Cross
  • 73
  • 12
0
votes
2 answers

Reading control from excel using smartxls api is not working

I was trying to read form control from an excel file. I am using smartXLS api. In my excel file cell "c2" has list-box (formControl). Now i want to read that that control . I was tried with following code but it throws an…
Chintan
  • 545
  • 1
  • 9
  • 24
1
2