General :: Combining Multiple .xls Spreadsheets Into One Document?

Nov 7, 2010

I have multiple .xls documents that are formatted as such,

<?xml version="1.0"?>
<?mso-application Excel.Sheet?>

They are all given different filenames bob_smells.xls, nancy_smells_worse.xls etc. I was wondering using Linux (LUbuntu specifically), would it be possible to combine all of these worksheets into one document, with each of the seperate files becoming a tab / sheet within the one file (And the name reflecting the original name of the document)?

View 2 Replies


ADVERTISEMENT

Programming :: AWK - Combining Multiple Columns?

Feb 23, 2010

I have a folder with only 24 files named <number>.dat (i.e. 4.dat, 6.dat and so on) where <number> is between 0 and 256. Each file has just two columns of data and nothing else.

I'm trying to combine all the second columns ($2) together. I've been fiddling around with getline and so far have

awk '{ getline ln < "6.dat" ; print ln" "$2 }' 4.dat

which takes file 4.dat and adds $2 from 6.dat, but I want a single command to take each $2 from every file and add them to (for example) 4.dat (having $1 from 4.dat is no problem). A command that takes every file in the folder and grabs $2 and places them in a common file would be ideal. Frankly I can work around if you combine both columns from every file.

View 5 Replies View Related

Networking :: Combining Multiple Interfaces With Multicast?

Apr 1, 2010

I have 4 interfaces, dvb0_0 - dvb0_3. Each one has a multicast stream coming in on it. The program I am using to decode these streams only accepts one interface though. How can I "combine" so that the program, listening on 1 ip can get all 4 streams? they are on groups 224.0.1.1-4

View 1 Replies View Related

General :: Combining Records With Same Key?

Apr 4, 2010

Input file (already sorted on the key field):

204 Daniel Barton
206 Mary Halston
206 David Coleman
206 Carson Coleman
207 Roland Highsmith
207 Annie Highsmith
209 Connie Ward

Desired output file:

204 Daniel Barton
206 Mary Halston David Coleman Carson Coleman
207 Roland Highsmith Annie Highsmith
209 Connie Ward

View 1 Replies View Related

General :: Combining A Badblock Scan With A Time Output

Jul 7, 2009

I have a Lenny Raid-5 setup, and I use rsnapshot to occasionally backup the raid to an old external hard drive that I otherwise leave unplugged. That external went bad, so I figured I should setup its replacement with encryption and keep it off site when not in use.

While googling and coming across LUKS, I can across this post this post that mentioned the drive should be be filled with random data before setting it up for encryption, and had the following as a potential sufficiently-good option over the time-intensive dd /dev/random route:
badblocks -c 10240 -s -w -t random -v /dev/sdx

I was unfamiliar with badblocks, and came across this post after a google session which noted the time duration of scan is an important factor as well as the result.

I sshed into the NAS, and was about to run badblocks first in read mode, then in write mode, but then I considered the time consideration. I was going to use something similar to the following: nohup badblocksstuff &

My Question: Is there a way I can append to the resulting nohup.out a time to complete value?

View 3 Replies View Related

Ubuntu :: Looking For OpenOffice Alternative For Spreadsheets

Sep 12, 2010

So I'm trying to create a spreadsheet that operates in hexadecimal, binary (maybe), and decimal, for fairly large values. While openoffice does handle hexadecimal fine, if you convert it to decimal (at least so far, if anybody has a more naturalistic way of doing this, that would be great), it can't seemingly handle how large the values are, and truncates. So, if possible, I would like an open source alternative that is perhaps more robust than OpenOffice. Hopefully one exists.

View 4 Replies View Related

Software :: Alternative Of Password Spreadsheets

Dec 27, 2010

What could be the best alternatives of password management. Keeping password protected spreadsheets becomes difficult when it have to be accessed by a group of people.

View 3 Replies View Related

Software :: OpenOffice.org Broken - Can't Access My Spreadsheets

Nov 23, 2010

I installed OOo on Slackware linux 13.1 recently. It worked fine until yesterday when I tried to open up an xls file which I often use, and I was presented with a "filter" dialogue with loads of options but no explanation what they were for. I tried several of them but nothing seemed to make any difference - the file was unopenable. I found a suggestion online that I should try to delete my configuration file ~/.openoffice, which I did. Unfortunately now whenever I open OOo I get a smaller dialogue box with some gibberish in it. It's some crazy wingdings font or something, and I have no idea what it's trying to tell me.

Anyway now I can't access any of my files. I have tried reinstalling OOo and deleting my config file again, neither does anything - i'm always getting the nonsense dialogue box. I have even installed OOo on a virtual WinXP and the same happened there (the 'filter' dialogue not the gibberish font)Has OOo somehow managed to corrupt ALL my files?

View 12 Replies View Related

Ubuntu :: Get Xsane To Scan A Document And Have It Display As A Full 8.5x11 Sized Document Instead Of Something Half That Size?

Mar 13, 2010

how to get xsane to scan a document and have it display as a full 8.5x11 sized document instead of something half that size? I've been trying and trying and can't seem to figure it out.

View 3 Replies View Related

OpenSUSE Network :: Document Is Referencing 10.2. Or A Document For Use With SLED?

Jul 6, 2010

Anyone have better documentation or an update to the this version of the file Tomcat HOWTO openSUSE as that document is referencing 10.2. Or a document for use with SLED.

View 3 Replies View Related

Ubuntu :: Find - Restore Lost Libre Calc Spreadsheets?

Jul 2, 2011

My low-down lousy computer crashed while I had two spreadsheets (Libre Calc) open. When I re-booted the 'tater, then clicked on the launchers for my spreadsheets, Libre Calc opened new, blank documents.

Is there a way to find the lost spreadsheets? If I can't have the whole things, then just the data would be OK.

View 3 Replies View Related

General :: Parsing Text And Combining The Parsed Text?

Oct 28, 2010

EDIT1: I should note that I was trying to do this in PERL, not sure if other alternatives are more simple?EDIT2: I should note that for text file 3 (reference), it's a long list of MANY cnp_id values and their corresponoding chr, start, and end values. So, the code will have to take the cnp_id from text file 1 and/or 2 and search through textfile 3 (reference) to match on the cnp_id and then take the corresponding chr, start, and end values and add to the relevant line in the output.EDIT3: Sorry, I should mention that the text file entries are all tab-delimited.I have 3 text files:File 1:Columns represent sample IDs (sample_id) and rows represent CNP IDs (cnp_id). Cells represents the confidence level (confidence) for each sample and CNP.Quote:

cnp_idP5E6_SNP6.0_JHP5_010408.CELP5E11reh_SNP6.0_JHP5_011808.CELP7C7_SNP6.0_JHP7_021208.CEL ... etc.
CNP100.0044798340.0027929510.00305613

[code]...

View 6 Replies View Related

Fedora :: Combining 2 Systems Into 1?

Mar 31, 2009

I have been running one computer with Fedora 9 and one with Windows XP Pro. to conserve space, I have moved the Fedora hard drive into the Windows computer (newer). Both are sata drives and each boots completely on its on. I would really like to make it a dual boot system so I can choose which drive to boot without having to open the case and swap the cables around. The Linux disk is readable by the windows OS but not the other way.

Everything I have read about dual-boot is how to do it at installation time. Is there anyway to do it, without reinstalling one of the OS.

View 5 Replies View Related

Ubuntu Multimedia :: Combining Two Dvd Into One?

Jan 26, 2010

Is there any software that will allow me to combine like DVD Shrink does? Without having to convert them muliple times. In DVD Shrink, you open one titleset and choose the movie you want and then open the second titleset and then do the same, and have DVD Shrink combine and shrink them into another titleset, then I make a menu with Titlewriter.

View 4 Replies View Related

Software :: Combining OGV Files Into One Big File?

Jan 2, 2011

I've tried several methods without success. These OGV files are 7 parts of a single screen cast. I tried ffmpeg but every option I try I either get crappy video or the audio/video is out of sync. Latest attempt was:

Code:

ffmpeg -v 9 -i XDF_Demo-PART-0-video.ogg -r 15 frames-part1/XDF_Demo_%06d.png

But that failed because the png quality. mplayer and mencoder I mostly just couldn't get it to play the files together. easy way to combined these files so media players and html5 can play it in one pass?

View 1 Replies View Related

OpenSUSE Network :: Combining Vncviewer Switches ?

Mar 21, 2011

I use vncviewer (win32) to connect to my SuSE 11.3 box. The SuSE box has the "standard" xinetd started Xvnc server running (includes the -inetd switch).

My client (the vncviewer) has to go through a firewall with limited ports available and so I use the command line:

Code:

However, if there is a problem with the connection, such that the client disconnects, it seems that subsequent request to the Xvnc server create a new session/display. The text in the client window reports "nobody's x11 desktop (host:1)", then "...(host:2)", then "...(host:3)" etc.

I have tried combining the display and the port parameters, like this:

Code:

Can anyone suggest an alternative way of reconnecting to a broken vnc session?

View 1 Replies View Related

Ubuntu Multimedia :: Audacity And Combining MP3 Files?

Mar 1, 2010

So I asked around and to combine audio files apparently I want to use Audacity.

It seems easy enough to LAYER audio files, but how do you string them together in sequence? I have an audiobook divided into 5 minute chapters and I want to combine them into longer chapters....my MP3 player likes to play them out of order which makes them difficult to listen to. I want to make it 1 long tract, or maybe 6 medium length tracks.

How do I combine tracks with Audacity...Not layering them but putting them in order into 1 long track?

View 5 Replies View Related

Software :: Combining An Archive And Script File

Oct 30, 2010

So what I am looking to do is combine an archive and a script file. I would like to have a number of files compressed into an archive package and when a user double clicks on the package instead of having it open with the archive manager, instead have it run a shell script that is also packaged with the files.

This shell script will do a number of things including handling where the files are extracted to. Over all this would be similair to a self-extracting installer Windows users are used to using.

View 5 Replies View Related

General :: Use 'iw' To Create Multiple Virtual Interfaces To Connect To Multiple Networks?

Oct 26, 2010

I'm trying to connect one computer to two others in an ad-hoc infrastructure.

[computer 1] ---- [computer 2] ---- [computer 3]

computer 2 is running Linux and has a single NIC wlan0. I want to it to connect to both computer 1 and computer 3 so each computer can talk to the other. No switch is available so it needs to be an ad-hoc setup.

[Code]...

View 1 Replies View Related

General :: Rename Multiple Files In Multiple Directories/subdirectories Recursively?

Aug 23, 2010

I am to rename all the files within a directory (which contains multiple subdirectories) recursively without invalid characters.

I tried the coding posted above.

find . -type f -printf '%p
' | while read file; do
oldfile=$(basename "$file")
newfile=$(echo "$oldfile" | sed 's/[^A-Za-z0-9_.]/_/g')
if [ ! "$newfile" == "$oldfile" ]; then
echo mv "$file" "${file%$oldfile}$newfile"
code....

but I get an error on both of them stating "find: bad option -printf find: [-H | -L] path-list predicate-list"

View 9 Replies View Related

General :: Good Support To Multiple Desktops AND Multiple Monitors

Jun 4, 2010

I'm starting to have A LOT of opened windows in my machine. Sometimes within a project, I have e-mail/task management/personal e-mail/twitter, and a lot of different opened applications/terminals in my Linux workstation.Sometimes it would be interesting to have different workspaces to projects instead of this configuration I have nowadays that are classes of work (bad name, I know, but I think you got the idea).I'm starting to think about using two monitors: one with Corporate Management, Work and Personal. The second monitor is only the development state: each workspace here is about a project being worked on instead of groups of works like before. A workspace may be implementing different classes for example.

My question is: I just want to change to a second monitor using the mouse. I want to still be able to change workspaces in the same monitor using keyboard shortcuts. The keyboard shortcuts wouldn't change monitors, just worskpaces on the same monitor. All the tutorials I read (like this one) only tells how to use multiple monitors but doesn't answer my question about keyboard shortcuts.Does Linux (Ubuntu 10.04 Lucid Lynx or Debian 5.0.5 Lenny) support this envisioned setup (Different workspaces in a way that keyboard workspace switching only works in the current monitor) ? If so, how?I haven't tested this setup, that's why I'm asking. In this question the user says it works exactly how I want it to behave, can someone else confirm it?

View 3 Replies View Related

Ubuntu Multimedia :: Combining Streams Of Video Into One File?

Feb 6, 2011

I'm looking for a program of some kind that I can combine 4 (if not 2 minimum) streams of video into one file. The only program so far that I've found that does this is avisynth but I can't seem to make it work at all. Does it even work under ubuntu? I've tried numerous guides and how to's but nothing seems to be working.

Basically I just need something that will take a video file, from several different sources (cameras placed around a car) and be able to place them in a grid form into one file. Basically in a format like this, where each letter is a different video file:
a b
c d

View 5 Replies View Related

Programming :: Combining Commands And Var's In Bash Shell Script?

Jan 5, 2011

I have a command which on the command line needs to look like this

rlam -if3 '!pvalue -H image1.jpg' > image2.jpg

Nevermind what rlam or pvalue do ... they are part of a program package I am using. The above command works on the command line, and also when written verbatim in a bash shell script.

My problem is: in the script I wish to replace image1.jpg with the content of a variable, e.g.

IM1=image1.jpg

How to I get the script to insert the value of $IM into the command when the pvalue part of it needs to be quoted?

View 1 Replies View Related

Software :: Combining Antivirus Data / Image Recovery?

Aug 9, 2010

I tried the Linux-based live CD's of the main Windows anti-virus vendors (Kaspersky, BitDefender, AVG, Avira). They work well, but they are single-purpose solutions while affected Windows users also need a solution to 1) pull data (or what's left of it) out of their contaminated Windows host onto a USB thumb drive or a remote host, and 2) restore a clean image using eg. CloneZilla. Asking users to burn and run three different CD's is not very user-friendly. Has someone already investigated combining those three features into a single live CD?

View 8 Replies View Related

General :: Apache Can't See Document Root

Feb 9, 2011

I have set up apache on Centos 5.5 and am struggling with vhosts set up.With the config I have set apache will correctly serve sites with a document root of

/var/www/html/home/myuser/public_html
but not /home/myuser/projects > ls -al
shows public_html and projects as having identical permissions (755)

View 11 Replies View Related

General :: Multiple Servers Or One Server With Multiple VMWare?

Feb 7, 2011

I'm looking at setting up a couple automated systems: Here are a few examples:

* Internal accounting system to download and process emails
* Public web server to visit

I could put each system on its own separate box -- for example, it's generally good practice to separate anything that external users have access to (such as a webserver) from internal processes such as accounting. Now, rather than dishing out the money for two separate servers, could I get away with just installing new instances of VMWare on the same box for each system?

To give you an idea, these are not large scale computationally sensitive systems. The accounting one is simply downloading and tallying emails, and the latter is just a webserver with maybe 5 hits per day on a good day. I could definitely pick up a new box for say $50, but I wanted to know the general practice of using VMWare on the same box versus two separate boxes.

View 2 Replies View Related

General :: Search Multiple Words In Multiple Lines?

Dec 16, 2010

How to search multiple words in multiple lines, inside a directory including sub-directory? Pls. give easy example. I want to search the files (in /xx folder and all subfolders) that have header.h included and used x() function. I tried $grep -r "header.h" | grep -r "x(" /Folder/subfolder/ > search.log

View 7 Replies View Related

Ubuntu Multimedia :: Video Editing Application For Combining At Framelevel?

Oct 17, 2010

I want a video editing software for combining two videos at frame level. I mean, for eg: to show double action at a time in movie. We shoot two characters separately. And then we combine it

View 1 Replies View Related

CentOS 5 Server :: Configure Cluster For Combining Cpu / RAM / Hard Disk

Jan 8, 2010

i want to configure a cluster for combining CPU / RAM / Hard disk

View 3 Replies View Related

General :: Converting Word Document To TIFF?

Apr 26, 2011

I have a CentOS 5.6 box and was wondering if there are any tools for Linux that can convert a Microsoft Word document to a TIFF file?

View 2 Replies View Related







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