Programming :: Process Ms Excel Files On Machine?
Mar 2, 2010Are there any solutions by which linux-based web server frameworks (like zend or any other) can process data inside microsoft excel spreadsheets (*.xls)?
View 1 RepliesAre there any solutions by which linux-based web server frameworks (like zend or any other) can process data inside microsoft excel spreadsheets (*.xls)?
View 1 RepliesI'm completely new to scripting and I'm trying to figure out how to write a script that will get a list of all the files in a directorywn through any subdirectories.When I have the list I want to o each file in VI and change the fileformat. So far all I have been able to figure out is that VI can do the batch processing and that "ls -R" gets me the recursive file list. I'm still pretty clueless on how to do the batch process with the VI editor. I think I'm supposed to use the Ex mode but I don't know how to get the list of arguments from the filelist into the editor so they can be processed. If it matters the files were all written in a Windows editor and have gotten the MS carriage returns so I want to do a :set ff=unix command on all the files without having to go into each file manually, there are over 300 files that need updated.
View 3 Replies View RelatedI cannot open .xls of .ods documents. Something I have altered recently may have done this. If I right click open with options I cannot find Open office. pdf files are opening with Okular as default. Previously Excel files opened with Open Office as default.Open office appears to be installed. how I can get these files to open and set it as default again.
System: openSUSE 11.2 (i586)
KDE: 4.3.5 (KDE 4.3.5) "release 0"
In shell, I execute "./ffmpeg -f h264 - | xxx"
Now I hope use execl function to execute above operations,
I call execl("/bin/sh", "sh", "-c", "./ffmpeg -f h264 - | xxx");
but ffmpeg doesn't work, it seems that "|" pipe don't work.
how could I solve this?
how to generate excel charts from C, or if it's possible at all? For example, if I had 2 arrays that I wanted to export to excel and graph against each other. I know how to export it to a csv file, that's no problem, but I have no idea where to start with generating a graph of the data. I can't seem to find any examples anywhere. Just a simple example to show you what I mean: Code:
char arr1[] = {'a','b','c'};
int arr2[] = {10,20,30};
int main ()
[code]....
Does anybody know how to generate excel charts from C, or if it's possible at all?
For example, if I had 2 arrays that I wanted to export to excel and graph against each other. I know how to export it to a csv file, that's no problem, but I have no idea where to start with generating a graph of the data. I can't seem to find any examples anywhere.
I'd appreciate if someone could point me in the right direction.
Just a simple example to show you what I mean code...
Can't use Excel files with Open Office. When trying to edit and fill out a RMA form using Excel file I keep getting a message saying: 'Protected cells can not be modified'.
Here's a screenshot. What do you have to do to get it to work with Ubuntu? Excel works fine with Windows but I can't use Excel on Ubuntu with Open Office. This is the first time ever using Excel with Ubuntu and Open Office.
I need to write a script (possibly awk) that is able to process 2 files, but I am very new to awk and I have problems in how to process 2 files at the same time.The first input file is samples.txtthe formattime_instant measure
Code:
903.0 -
906.43 18.4
[code]....
I am having trouble getting some code to work. It takes an input file (csv) and converts it to an XLS. The problem is that I can't seem to get a header to be printed first...
Code:
use Spreadsheet::WriteExcel;
my $input = $ARGV[0];
[code]...
I have a LAMP based web hosting account (BlueHost). I have an existing simple MS Excel application which I would like to make it web based. However I am not sure what tools or features of PHP are out there that will aid me with this task. Here are some details:
1. I don't want to create an entire Excel program online. For that there are plenty of existing applications like Google Docs, MS's own online version of Excel, etc.
2. My current excel file uses some of the following excel functions:
a) SUM
b) Product Sum
c) Conditional Formatting (like changing font color if an amount is below a threshold, etc.)
d) Sorting (Date, Amount)
e) Drop Down Box to select pre-defined values
3. Ability to add/delete/modify a entry (row)
4. I don't care whether the application has the same look-n-feel as MS Excel.
As you can see it is a very simple home grown excel application with few basic mathematical functions. Here are some few thoughts that I have currently in my mind:
i) Just start coding intuitively as you would develop a normal web based application.
ii) Do (i) but use some of the PHP's excel oriented helper functions (COMs?) if there are any
iii) Use completely a different set of tools permitting that they run on LAMP environment.
I could have started with (i) but before making a costly mistake I thought I would get some opinion from the community to see if this is the right approach.
My nephew dropped in today hoping I could print off some large Excel files. When I opened them in Office Spreadsheet I could see that each cell had a series of dots in it, similar to full stops (periods). These dots even occurred in cells that already contained text or numbers. Evenly spaced horizontally and vertically as if marking the corners of squares and regardless of the row height or column width. This wouldn't look good on a print out and being as he wanted them for a new job we booted up a Windows machine and took the printout from there. It turned out the page was intended to print to an A3 sheet whilst my available printers are all A4.
Later I reloaded these files into OpenOffice (3.2.0) because I was niggled about OpenOffice perhaps not achieving a decent performance against Excel, and printed off a couple of pages. The printout showed no sign of the dots, which is fine, but what about these dots that show up on the Spreadsheet page.
A bit more on this is that they show up in Preview in Web browser but not in Page preview. Any corrections on this admittedly trivial problem or do we just live with it?
We started upgrading our office package to office 2007. No problems right off the bat, but all of a sudden there are excel files stored on our linux file server that people store and share. Some of them you can open and some of them you can not open and it doesn't give a reason you can't open them it just says can't open file anyfile.xls..I attached a word doc with pic of error in excel.
View 6 Replies View RelatedI have xubuntu 9.10 installed I need to access MS word/Excell files stored on a disk-on-key. My system does not seem to notice the D-O-K. I guess i need to mount the DOK and specify the MS filesystem (FAT,VFAT etc) What commands should i use. What is the necessary code in /etc/fstab so that it is mounted on boot
View 5 Replies View RelatedImported an Excel file into OO.o Calc. EVerything is fine except the comments are all blank. It knows that comments should be there, but they're all empty. how to recover the contents?
View 2 Replies View Relatedi am using linux for the first time. i have been given a project which will fetch data from csd(comma separated form) and ll display on d screen. i want a c program for linux which ll do the above given task. moreover i want the parameter file(such as location of file, file name,etc..) as a different file. so that i can access this program on any computer.
View 3 Replies View RelatedI have an Excel Spreadsheet which reports upon weekly performance. One portion of the worksheet looks at week over week increases /decreases. I've placed a number of image controls (15 in Total) next to cells which calculate week over week change. The image controls simply display an image depending on whether the value of the adjacent cell is positive or negative. So, here is my basic working IF statement:
Code:
Private Sub Worksheet_Change(ByVal UpDown As Range)
If Range("J26") > 0 And IsNumeric(Range("J26").Value) Then
Image1.Picture = LoadPicture("C:path oup_arrow.gif")
ElseIf Range("J26") < 0 And IsNumeric(Range("J26").Value) Then
[code]....
As you can see, this is pretty simple. What I'd like to do is find a way to loop through all 15 controls and avoid having 15 IF statements run on the Worksheet_Change() event. The cells containing the week over week values are all in the same column, but not continuous. Involved cells are: ("J26", "J27", "J33", "J34", "J35", "J36", "J37", "J38", "J39", "J40", "J42", "J43", "J44", "J45", "J46")
Looking for an open source solution to convert pdf file to excel document.
View 1 Replies View RelatedI am going through a multi-step process to produce output files, which involves 25,000 greps at one stage. While I do achieve the desired result I am wondering whether the process could be improved (sped up and/or decluttered).input 1set of dated files called ids<yyyy><mm> containing numeric id's, one per line, 280,000 lines in total:
Code:
123456
999996
[code]....
I have a shell script to identify whether the process is running or not. If the process is not running, then I execute another script file to run my application. Below is my script and saved this script as monitorprocess.sh Code: #!/bin/bash
result=$(ps -ef | grep -v grep | grep "applicationname.sh" | awk '{print $2}')
echo $result
if [ "$result" == "" ];
[code]...
Is there any difference in cpu usage for process in init.rc(runs automatic when boot is happened) and manually running process. Will these both have same priority by default...?
View 1 Replies View RelatedI tried googling but didn't get any answer for this.I have a process called "abc" and it is running with PID "123".I have a putty session opened with PID "999".I am giving kill -TERM 123 from putty session.My process "abc" before dying it should catch the PID of the terminal which provided TERM signal to it.Is there any way to find this out
View 2 Replies View RelatedHow do you transfer files on a Linux machine with ftp,sftp and scp disabled onto a remote machine
View 2 Replies View RelatedI have been trying to SCP a couple files from my Ubuntu 10.10 machine to a Fedora 12 machine. Before today, did it with out any problems, always worked. Today however; after the SCP is complete from my machine, the file on the other machine is zero bytes, an empty file. The only thing I can remember getting changed was the new kernel that was in the update I did today. But I don't think that would have changed the SCP works.
View 5 Replies View RelatedI had run one script in unix machine and want to copy the results to a windows machineBoth the machines are on different networksIn linux machine trying to do the ftp to the windows machine its giving connection refused. How to chech whether ftp is running on that linux machine or not?Also tried scp and ssh , both are failing
View 6 Replies View RelatedI have a shell script to identify whether the process is running or not. If the process is not running, then I execute another script file to run my application. Below is my script and saved this script as monitorprocess.sh
Code:
#!/bin/bash
result=$(ps -ef | grep -v grep | grep "applicationname.sh" | awk '{print $2}')
[code]...
How can i copy a files from Machine A to Machine B.Which is LAN connected
View 4 Replies View RelatedI want to kill parent process after "fork()" method. but if I kill parent process with "exit(0)" method, main() thread is terminated as well so child prosess doesn't work anymore. Is there any way to kill only parent process without affecting to child process?
#include <sys/types.h>
#include <sys/stat.h>
#include <fcntl.h>
[code]....
what are the programs or process that gets execututed when a linux start. ie starting from the grub (linux bootloader)
View 3 Replies View RelatedI'm having small boot issue with my present Linux box, which is presently running Ubuntu 8.04 LTS. When booting from a Live CD, Ubuntu 9.xx+ or any other linux variant I have, the machine will come to a complete stop about half way into the boot process. I think this may have something to do with the WiFi card that I have installed. Are there any suggestions that could help me remedy this problem short of removing the card itself?
View 9 Replies View RelatedConsider the following code:
Code:
int main()
{
int i=0;
pid_t pid;
for(i=0;i<2;i++)
[code]....
I get the following output:
Parent: chid_pid=4356 i=0 parent's pid=4355
This is child 4356 i=0
This is child 4357 i=1
[code]....
I can observe instead of two children(as I expect) processes there are three. This is because child process 4356 creates its own child. Why all the messages of the type "This is child X i=Y" are concentrated one under another? How exactly fork works? Is affected by the fact that I have a dual-core processor?