How can I access password protected Excel workbook in Java using POI api
- by Umesh
I want to read from and write to password protected Excel files. How can I do so using Apache POI API.
Thank You,
Search Results
Search found 4547 results on 182 pages for 'applescript excel'.
Page 98/182 | < Previous Page | 94 95 96 97 98 99 100 101 102 103 104 105 | Next Page >
-
-
merge excel cells using pyExcelerator
- by zhangzhong
I want to merge two cells in excel using pyExcelerator , ws.write_merge(r1=0,r2=1,c1=0, c2=0, label='test1', style=style1) #merge cell1(row=0, column=0) with cell2(row=1, column=0) Why the errors happen? AssertionErrors,0 < 0 errorsRead the article
-
Read all the cell values from a given range in excel
- by Sathish
Read all the cell values from a given range in excel in csharp suppose i have range from E2 to E16 i want to read values from cell E2 to E16 please helpRead the article
-
Embedding HSSF(excel) into HSLF(ppt) using apache poi
- by sankar
I want to embed the excel sheet into presentation(PPT) using apache poi. how can we do this? If anyones knows, please help me.Read the article
-
How to apply filters to agridview like applying filters to excel sheet
- by joy
hi i am doing an application where i am populating the grid from databse by passsing different parameters to the stored procedure and getting data to a datatable and binding it to the grid view. now i need to have filters applied to the grid so that it should just work like the filters applied to a excel sheet. can i have some piece of code for applying filters to the gridview with out changing the design of the gridRead the article
-
Convert the mysql table details to an Excel(.xls) or comma seperated file(csv) using python
- by nimmyliji
Hi, I want to convert the mysql database table contents to an Excel(.xls) or comma seperated file(csv) using python script... Is it possible? Any one can help me? Thanks in advance, NimmyRead the article
-
Adding and Naming TABS to excel reports in Microsoft Reporting Services
- by GordyII
In Microsoft Reporting Services, I want to be able to name the tabs for the resulting document when a excel report is generated. Does anyone know how I can do this?Read the article
-
How do I safely deploy an Excel 2007 Workbook with .net VSTO functionality
- by Chris
I have a VSTO Excel workbook that functions correctly in test. I can deploy the package (publish the solution) but when I distribute it my users are unable to install it. Any idea, any way to ensure that all necessary install files follow the package?Read the article
-
Crystal report export to Excel with wrong page size
- by Brian
I have designed the report in A4 size, When I export to PDF, the size fit well. However, when I export the report to Excel 2000/2003, the report cannot fit in a page. Could anyone tell me how to fix it ? ThanksRead the article
-
Upload Excel or CSV file to MySQL with PHP
- by Tony
I'm looking to allow users to upload an Excel or CSV file to MySQL for a contact management system. Need to be able to allow users to map their columns so that they are imported into the correct column in the table. Anyone know of a good site or tutorial on this?Read the article
-
Close Office applications (Word, Excel, Outlook) before install an Office 2007 Add-in
- by Martin
Hello All, How can I close any Office 2007 running application like Word,Excel,Outlook before installing an Office 2007 Add-in in a Visual Studio 2008 Setup Project? Thanks! MartinRead the article
-
Zend Framework PDF to excel type
- by Uffo
How can I make something like this with Zend_PDF: I have a few columns A, B, C, D, E and after them I will have some information, something like excel. A | B | C | D ss|das|dad|ds ss|das|dad|ds ss|das|dad|ds How can I create something like this with ZF_pdf? I will pull the data from DB, can you please give me an example?Read the article
-
Opening Ms word/ Excel / PPT AND PDF in Flex
- by Manan
Hi , I am looking for a solution preferrably 3rd party component , to open / disply word/excel/ppt and PDF document into flex : Flow is like this : User uploads any of the file .doc/.docx/.pdf/.ppt etc . This file is then displayed in flex area , without having user to get Office . ( Office WEB Component ) is ruled out because it needs office to be installed already . print2flash.com sounds good but their problem is they are on windows , my setup is LAMP PHP / mysql over Linux . ThanksRead the article
-
SSIS Excel Destination with format
- by user308551
Hi guys, I try to export excel file with some format like: Interior.Color HorizontalAlignment Font.Bold and etc.. So the question is, can we do like that is SSIS.. and how to do it?Read the article
-
How to export to excel jquery grid data using jquery
- by kumar
Can any one help me out how to export the jquery grid data to excel? i have inserted one button call export? $("#Export").click(function(){ I am little confuse what should I write? }); thanksRead the article
-
How to know the formatting of Excel Cell
- by Sathish
Is it possible to figure out the Format of Excel cell i know there is .NumberFormat but it returns the formatting but not the type... basically i need to know if it is custom then it should return custom and if it is currency it should return Currency or any other datatype Please help meRead the article
-
How can i get the Cell address from excel
- by Sathish
How can i get the Cell address from excel given a row and column number for example row 2 and col 3 should return C2... Please helpRead the article
-
How to convert excel file into mdf file
- by rajesh
i have an exel file. i want to change this file into mdf formmat. Plz tell me the full procedure, how i can convert this file. i m using excel 2003 nd sql server 2000.Read the article
-
getting html source with excel-vba?
- by every_answer_gets_a_point
i would like to direct an excel VBA form to certain URL's and get the html source and put it in a string. is this possisble?Read the article
-
BizTalk mapping to excel
- by rsapru
Is there a way to convert or get the mapping from BizTalk map to an excel or a text file. From where we can directly see what field is mapped to what filed instead of following the lines. I have an BizTalk map which had around 600 fields mapped. any pointers will be really helpful.Read the article
-
How to parse a date from an SSIS Excel filename
- by user327045
I want to use the foreach container to iterate through a folder matching something like: "Filename_MMYYYY.xls". That's easy enough to do; but I can't seem to find a way to parse the MMYYYY from the filename and add it to a variable (or something) that i can use as a lookup field for my DimDate table. It seems possible with a flat file data source, but not an excel connection. I'm using Visual Studio 2005. Please help!Read the article
-
Check excel file is open by other user
- by Ankata
Dear all, I have a excel file place on server. I am using a application which written by VB.NET to open file in read only mode. User 1 open file in read only mode. How can user 2 detect that file is open or not status? Thanks, AnRead the article
-
How important are Excel Skills for a developer?
- by dotnetdev
As a software developer (leaving junior position, now taking mid-level), how important are Microsoft Excel skills? I ask as I have done this extensively in one job but is it reall a skill that will help in future jobs? ThanksRead the article
-
Reading opened Excel file by OLEDB
- by Sathish
I am using OLEDB method to read an excel file, however if the file is closed then there is no issues but if the file that has to be read is open then if i use oledb i get an error. Any workaround for this??????? Please help....Read the article
-
Export pdf table to excel
- by Nagu
Hi, anyone know how to export pdf table to excel using c# and asp.net? if any can you give me a sample code snippet? thanks in advance naguRead the article
