Tag Archives: api

JEXCelAPI on android

Questions: When I added the JExcelAPI http://jexcelapi.sourceforge.net/ to the class path and run my app, I get: trouble writing output: shouldn’t happen [2009-07-16 14:32:19 – xxx] Conversion to Dalvik format failed with error 2 any idea? thanks Answers: I have seen this error on android when using the example tutorial code from jexcelapi site. E.g… Read More »

Excel File download through web api. Getting corrupt

Questions: I am trying to download a excel file through Web API (using Entity framework). The download is working but I am getting some error dialog about file corrupt when trying to open the file. Web API code as below: public HttpResponseMessage GetValue(int ID, string name) { MemoryStream stream; try { using (DataContext db =… Read More »

Request body for Table/Range related method are missing in the documentation of microsoft graph excel api

Questions: I created a table using: /v1.0/drives/{driveid}/items/{id}/workbook/worksheets/Sheet1/tables/add with the request body: { “address”: “A1:C2”} Unable to set data onto the table using: /v1.0/drives/{driveid}/items/{id}/workbook/worksheets/Sheet1/tables/Table2/Range with the request body: { “values”: [[“a”, “b”, “c”], [“1”, “2”, “3”]] } Getting this error: { “error”: { “code”: “InvalidArgument”, “message”: “The argument is invalid or missing or has an incorrect… Read More »

scraping a webpage using vba

Questions: I am trying to scrap information from multiple web sites. <div class=”detailSection”> <span>Officer/Director Detail</span> <span><b>Name & Address</b></span> <br/> <br/> <span>Title&nbsp;VD</span> <br/> <br/> GUNN, BETTY <span> <div> 6922 SOUTH LAGOON DR<br/> PANAMA CITY BEACH, FL 32408<br/> </div> I am able to pull all of the information except for the name “GUNN, BETTY”. The web page… Read More »

Coldfusion: using Apache POI event API

Questions: I need to parse big Excel spreadsheet (approximately 20 sheets) sheet by sheet with ColdFusion. cfspreadsheet tag fails when processing large amount of data with [java.lang.OutOfMemoryError: GC overhead limit exceeded]. Apache POI User API directly behaves the same way: <cfscript> pkg = CreateObject(“java”, “org.apache.poi.openxml4j.opc.OPCPackage”).open(JavaCast(“string”, fileName)); // error on next line wb = CreateObject(“java”, “org.apache.poi.xssf.usermodel.XSSFWorkbook”).Init(pkg);… Read More »

How to implement data validation in Excel using Office.js API

Questions: Is there way to implement data validation programmatically using Office.js API ? Answers: While you can absolutely implement your own data validation within an add-in, it would be distinct from the built-in data validation tool. There is currently no API for configuring Excel’s data validation tool programmatically.