I open excel file by JExcel, modify some cells and save it.
As result Array formulas({ ... } CTRL+SHIFT+ENTER) was broken.
Does anybody know what to do? (FormulaException is rasing during copy)
theproblemsolver has an example to show the status of workflow as image for wf3, the question is how to do the same thing in wf4?
http://msmvps.com/blogs/theproblemsolver/archive/2007/01/07/adding-activity-event-status-to-a-workflow-image.aspx
Hi everyone, this is my question:
I'm migrating data from a Btrieve file (.dat) through Pervasive Control Center and there is field type which is defined as integer but is a date and for example the date '31/12/2009' (seen in the legacy system) is view it as the number 733772 when I export it.
The legacy system shows the date correctly but I can't export it in the same format or at least I can't convert it. Does anybody know how to convert this number through Excel or something?
Is there a way to run a loop through a folder and process like 30 files for a month and give the average,max of each columns and write in one excel sheet or so??
I have 30 files of size [43200 x 30]
I ran a different matlab scrip to generate them so the names are easy
File_2010_04_01.xls , File_2010_04_02.xls ..... and so on
I cannot merge them as each are 20mbs and matlab would crash.
Any ideas?
Thanks
I am developing a VBA application which is quite large. I want to use SVN for that application developing.
How can I split my modules from the Excel document and how to upload my modules separately to source control?
Please help me.
I'm trying to load external data to my entyity.
DataServiceCollection<products> products = new DataServiceCollection<products>();
var adapter = new OleDbDataAdapter("SELECT * FROM [products$]", "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\\products.xlsx;Extended Properties=\"Excel 12.0;HDR=YES;\"");
DataSet ds = new DataSet();
adapter.Fill(ds, "excell");
products.Load(????);
Can anyone help ?
Ctrl+3 in Eclipse can do this:
http://techvj.blogspot.com/2007/11/any-software-developer-using-ide-begins.html
Is there an equivalent in Visual Studio? Or via some 3rd party plugin?
Hey ,Guys!
I want to use the method request.query_string to send the key-value to the controller,how can i use in the sentences;
=link_to 'excel' , reports_excel_path(:format => 'xls',:from => 'conversations')
Thank you!
I'm looking for a lightweight java reporting engine to be embedded in an applet application.
My first option was Jasper Reports, but the jar is over 2Mb, a little too heavy (and too bloated) for my needs. I don't know if there is modular jasper distribution, with funcionalities split in several jars (like html rendering, pdf, excel, compilation, runtime, etc).
I need to preview the report using Swing and print it. PDF export is a plus.
I need to import either csv or excel file into a dbase. The column headers will match but I will want to compare the file against the dbase using an ItemID field, list the rows to be affected and the differences, then allow an update to all the rows with the matching ID.
Case and point: I need to open an Excel file via Interop and it would help a lot to avoid ugly COM errors if I knew that the file was in use.
Other than trying to open the file and catching the exception, is there a programmatic way to determine whether the file is in use?
For those familiar with Excel, I'm trying to use a similiar NETWORKDAYS function within Cocoa.
Can anyone help with the type of info I'll need to construct an NSDate catagory that can give me only the working days betweek two dates?
many thanks
Nik
CountIF function in excel , How do I use the same function in
sharepoint Calculated Field.
I want count number of "GO" from Column 1 to Column 12
i.e. Col 1 "GO", Col 2 "GO", Col 3 "No GO", Col 4 "GO": GOs=3
So I want to make a program that allows you to store and search for user names/passwords for online sites there signed up to.
I know C# has some database options but I don't know much about it. I also heard that it can read/write excel files.
Whats do you think is best for storing the data?
ALSO do databases need to be stored online on a sever, or can they reside in the program
files?
I'm reading a text file via CGI in, in perl, and noticing that when the file is saved in mac's textEdit the line separator is recognized, but when I upload a CSV that is exported straight from excel, they are not. I'm guessing it's a \n vs. \r issue, but it got me thinking that I don't know how to specify what I would like the line terminator token to be, if I didn't want the one it's looking for by default.
JQuerry data grid with items&columns drag&drop, Items sort. Is there any?
So I need Dragable\Dropable Items
Drag and drop sorting of table columns
Sort Items in columns
You can taste how sweeet is Adobe Flex builder Data Grid and Its Drag-Drap here: http://blog.flexexamples.com/2007/09/19/dragging-rows-between-two-different-flex-datagrid-controls/
Is there any JQuery analog?
Hi,
I have to load excel file into sql server i use window application so i select filepath in textbox when click button using fileopendialogbox my problem is that i want ot provide list of sheets of file in combo box.
so user can select appropriate sheet to upload. Because it may possible that there are many sheets in file and tool doesn’t know which one to upload.
MY scenario is... I have 6,000 datas in Excel Sheet.. I try to import to Access Database.It enters the Database like this..
UNit Price 34512.00 Vat 4.00
BUt when i Retrieve to DataGridColumn it Shows vat Rate as 4(whole number).I accept zeros has no values..But I need that to be displayed in Grid as 4.0 . How to achieve this
When do I execute query COPY TO ... CSV, I create CSV file. BUt when open it column with names in excel that should be with national characters are not as it should be. So my question is, If it is possible within a sql query to change this encoding to utf8? Or something else? Because I want that new created CSV file to be as final product for user on web. I hope someone understood what I want:)
Hi,
dadasdf\sdasdasd\qazxbbjj\test.txt
Above is the string in cell A1 in excelsheet,I want to extract the last word from that cell.i.e,I want only test.txt,How can I acchive that using excel function.If it is acchived by declaring any variable then also help me out.
Why is encryption algorithm may give different results in AS3 and PHP?
In AS3 I use library from http://labs.boulevart.be/index.php/2007/05/23/encryption-in-as2-and-as3/.
And in PHP I use RC4 Cipher.
Could some tell me what is the problem? Thanks.
Hi,
I am wondering if anyone knows a java script library that would add a "select" type of functionality as seen in excel/google docs where you can click and select several different parts of a row and/or column. I am looking at adding this functionality to my web application. Does anyone know where of library's preferably in java script that will be able to add this.
Thanks in advance
I have created a shared Add-in for Excel and want to use App.config for some of the settings. I have read somewhere that i cant use app.config for shared Add in(dll). Please let me know is there any other way to read this config file
http://blog.flexexamples.com/2007/08/21/highlighting-a-slider-controls-track-using-the-showtrackhighlight-style/
in this above link have two thumb.In that one first thumb have the showTrackHighlight=true,ist posssible to use three thunb with showTrackHighlight.if so plz help mee
can any one please let me know, i need to print/list Alphabetical(A-Z) char to manage Excel cells. Is there any php function to list Alphabetic?
I need result as
A1
B1
C1
D1
...
...
...
OR
A
B
C
...
...