Programming :: Process Ms Excel Files On Machine?

Mar 2, 2010

Are 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 Replies


ADVERTISEMENT

Programming :: Batch Process Files In VI?

May 29, 2010

I'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 Related

OpenSUSE :: Excel Files Not Opening?

May 22, 2010

I 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"

View 3 Replies View Related

Programming :: Use Pipe In Excel Function?

Apr 13, 2010

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?

View 1 Replies View Related

Programming :: Generating Excel Charts From C?

Feb 24, 2011

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]....

View 5 Replies View Related

Programming :: Generate Excel Charts From C?

Feb 24, 2011

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...

View 10 Replies View Related

Ubuntu :: Can't Use Excel Files With Open Office?

Dec 9, 2010

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.

View 2 Replies View Related

Programming :: Write A Script (possibly Awk) That Is Able To Process 2 Files?

Oct 7, 2010

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]....

View 2 Replies View Related

Programming :: Can't Write Header To Excel File?

Jan 15, 2010

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]...

View 5 Replies View Related

Programming :: Making Existing MS Excel App Web Based

Jun 7, 2010

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.

View 1 Replies View Related

Ubuntu :: Niggly With Display Of Excel Files Using OpenOffice?

Nov 17, 2010

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?

View 1 Replies View Related

SUSE :: Office 2007 Excel Files Will Not Open

Jun 11, 2009

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 Related

Hardware :: Access A Disk-on-key With MS Word/Excel Files On It?

Mar 22, 2010

I 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 Related

Software :: Excel Files Have Empty Comments In OO.o Calc

Jun 24, 2010

Imported 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 Related

Programming :: C Program For Fetching Data From Excel Sheet?

Jan 31, 2011

i 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 Related

Programming :: VBA / Excel - Looping Through Image Controls Based On Cell Contents?

Jun 28, 2011

I 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")

View 6 Replies View Related

Programming :: Open Source Solution To Convert Pdf File To Excel Document?

Mar 2, 2011

Looking for an open source solution to convert pdf file to excel document.

View 1 Replies View Related

Programming :: Going Through A Multi-step Process To Produce Output Files, Which Involves 25,000 Greps At One Stage?

Nov 8, 2010

I 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]....

View 14 Replies View Related

Programming :: Displaying Process Id In Shell Script But There Is No Such Process?

Nov 9, 2010

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]...

View 4 Replies View Related

Programming :: Difference Between Init.rc Process And Normal Process?

Mar 31, 2011

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 Related

Programming ::get The PID Of The Process Giving Kill Signal To A Process?

Nov 26, 2008

I 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 Related

General :: Transfer Files On A Machine With Ftp / Sftp And Scp Disabled Onto A Remote Machine?

Nov 30, 2010

How do you transfer files on a Linux machine with ftp,sftp and scp disabled onto a remote machine

View 2 Replies View Related

Ubuntu :: Copy SCP A Couple Files From 10.10 Machine To A Fedora 12 Machine

Dec 8, 2010

I 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 Related

Networking :: Transfer Files From A Machine To A Windows Machine Which Are Not In The Same Network?

Jul 6, 2010

I 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 Related

Programming :: Showing Process Id But There Is No Such Process?

Nov 9, 2010

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}')

[code]...

View 14 Replies View Related

General :: Copy Files From Machine A To Machine B?

Mar 8, 2010

How can i copy a files from Machine A to Machine B.Which is LAN connected

View 4 Replies View Related

General :: Killing Parent Process Without Killing Child Process (Linux C Programming)?

Mar 10, 2011

I 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]....

View 1 Replies View Related

General :: Boot - What Are The Various Programs Or Process That Gets Executed When A Machine Starts

Aug 2, 2010

what are the programs or process that gets execututed when a linux start. ie starting from the grub (linux bootloader)

View 3 Replies View Related

Ubuntu :: Machine Will Come To A Complete Stop About Half Way Into The Boot Process

Aug 11, 2010

I'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 Related

Programming :: Under Which Circumstances A Child Process Creates Another Child Process Using Fork

Dec 7, 2009

Consider 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?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved