I have a few dozen excel files which are all of the same format (i.e. 4 worksheets per Excel file). I need to combine all the files into 1 master file which must have just 2 of the 4 worksheets. The corresponding worksheets from each Excel file are named exactly the same as are the column headers.
While each file is structured the same, the information within sheet 1 and 2 (for example) is different. So it can’t be combined into one file with everything in one sheet!
I've never used VBA before and I'm wondering where I might start this task!
I need a script to automatically delete the user profile left on ubuntu 9.04, anyone please send me this mail: [email protected] thank you, please indicate how I work not fluent in shellscript.
What is the significance of the ProjectTypeGuids tag in a visual studio project?? When I created a WPF application, i am seeing two guids in here.
{60dc8134-eba5-43b8-bcc9-bb4bc16c2548};{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}
Does these represent WPF and Windows type of applications?
If I create my own project type (.myproj) that has .xaml and .cs files, what should I fill in this ProjectTypeGuids tags? Should I also need to fill the ProjectType tag?
It would also be better if someone differentiate the ProjectType and ProjectTypeGuids tags.
P.S. I am using Visual Studio 2010 RC currently
Thanks
Hi there.
I have using Hg for some projects on my google code hosting. For each projects I set in [auth] section of .hgrc the username/password to push without every asking for password. But it is lots of duplication like:
[auth]
proj1.prefix = ... 111
proj1.username = google code username
proj1.password = google code password
proj2.prefix = ... 222
proj2.username = google code username
proj2.password = google code password
Can this somehow be doing with less duplications? Maybe set variable in hgrc and refer to it from all username/password lines?
Thanks in advance for your help
HI All,
I have site where the user upload the Videos. I want to generate a thumbnail from the video after it gets uploaded and store it in the hard disk. I want to do this using expression encoder in C#. Can any1 pls help me out. Thank you.
Title says it all.
The error NASM gives (dispite my working OS) is "invalid effective address".
Now i've seen many examples of how to use LEA and i think i gots it right but yet my NASM dislikes it. I tried "lea cx, [cx+9]" and it worked; "lea cx, [bx+cx]" didn't.
Now if i extended my registers to 32-bits (i.e. "lea ecx, [ecx*8+ecx]") everything would be well but i am restricted to use 16- and 8-bit registers only.
Is here anyone so knoweledgeable who could explain me WHY my assembler doesn't let me use lea the way i supposed it should be used?
Thanks.
Hi All,
I work as a web developer with a web designer and we usually do like this :
- I create the system , I generate some Xml files
- the designer display the xml files with xslt
Nothing new.
My problem is that I use Xml Serialization to create my xml files, but I never use Deserialization. So I'd like to know if there is a way to avoid fix like these :
empty setter for my property
empty parameter-less constructor
implement IXmlSerializable and throw "notimplementedexception" on deserialization
do a copy of the class with public fields
thanks.
how to creat exe of c program in linux,i think we need to use makefile,but i don't know whether we have to creat makefile and how to creat it,what is its extention ,how to run it.
I want to upload files outisde web server like in d d drive into servlets, I but I'm not able to upload them.
What I have to do to make functionality like this enable in Tomcat 6.0?
I am trying to get silverlight smooth streaming going on a site I am bilding and it works fine with the big buck bunny sample code which looks like this:
<object data="data:application/x-silverlight-2," type="application/x-silverlight-2" width="100%" height="100%" id="Object2">
<param name="source" value="SmoothStreamingBlackGlass.xap"/>
<param name="onerror" value="onSilverlightError" />
<param name="initparams"value='autoplay=False,muted=False,stretchmode=0,displaytimecode=False, playlist=<playList><playListItems><playListItem title="Big%20Buck%20Bunny" description="" mediaSource="Big%20Buck%20Bunny.ism/Manifest" adaptiveStreaming="True" thumbSource="Big%20Buck%20Bunny_Thumb.jpg" frameRate="24.0000384000614" ></playListItem></playListItems></playList>' />
<a href="http://go2.microsoft.com/fwlink/?LinkID=124807" style="text-decoration: none;"><img src="http://go2.microsoft.com/fwlink/?LinkId=108181" alt="Get Microsoft Silverlight" style="border-style: none" /></a>
</object>
<iframe style="visibility:hidden;height:0;width:0;border:0px"></iframe>
but if i change the code like this i only get a blank area when the page is rendered instead of the movie clip.
<object data="data:application/x-silverlight-2," type="application/x-silverlight-2" width="100%" height="100%" id="Object2">
<param name="source" value="SmoothStreamingBlackGlass.xap"/>
<param name="onerror" value="onSilverlightError" />
<param name="initparams"value='autoplay=False,muted=False,stretchmode=0,displaytimecode=False, playlist=<playList><playListItems><playListItem title="Robotica_1080" description="" mediaSource="Robotica_1080.ism/Manifest" adaptiveStreaming="True" thumbSource="Robotica_1080_Thumb.jpg" frameRate="24.0000384000614" ></playListItem></playListItems></playList>' />
<a href="http://go2.microsoft.com/fwlink/?LinkID=124807" style="text-decoration: none;"><img src="http://go2.microsoft.com/fwlink/?LinkId=108181" alt="Get Microsoft Silverlight" style="border-style: none" /></a>
</object>
<iframe style="visibility:hidden;height:0;width:0;border:0px"></iframe>
Any ideas? I am using Encoder 3 to do the encoding set on microsoft smooth streaming for 720p with all the default settings.
Hi all,
I'm new to mysql. My requirement is to import a sql dump into mysql using shell script for linux and this script should be called by java program for the restoration to take place automatically.
Please advice me on this.
Regards,
Chandu.
Hello.
Is there recommended order in which include files should be specified?
For example, the system files, STL, Boost, go before of after local include files?
is there a particular reason to choose one or another?
Thanks
I was attempting to install an exe that requires a serial number before the install, which the vendor has not provided to us yet.
This got my wheels turning about whether there is any information that can be gained from viewing an exe using a hex editor/VI/etc?
Using VI to view an exe, I can see some sections of plain text, but it is difficult to determine what it refers to without any context around it.
Is it possible to determine any information by reading an exe?
Thanks
In the below code i get an error saying Error #2007: Parameter url must be non-null on Ineternet explorer only.What am i doing wrong here
html
<OBJECT
classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
WIDTH="50"
HEIGHT="50"
id="myMovieName">
<PARAM NAME="movie" VALUE="/media/players/testsound.swf" />
<PARAM NAME="quality" VALUE="high" />
<PARAM NAME="bgcolor" VALUE="#FFFFFF" />
<EMBED
href="/media/players/testsound.swf"
src="/media/players/testsound.swf"
flashvars="soundUrl=sound.mp3"
quality=high
bgcolor=#FFFFFF
NAME="myMovieName"
ALIGN=""
TYPE="application/x-shockwave-flash">
</EMBED>
</OBJECT>
mxml
;
import flash.net.;
import mx.controls.Alert;
import mx.controls.Button;
import flash.events.Event;
import flash.media.Sound;
import flash.net.URLRequest;
private function clickhandler(event:Event):void
{
var musicfile:String;
var s:Sound = new Sound();
s.addEventListener(Event.COMPLETE, onSoundLoaded);
var req:URLRequest = new URLRequest("/opt/cloodon/site/media/players/sound.mp3");
//musicfile = stage.loaderInfo.parameters["soundUrl"];
//var req:URLRequest = new URLRequest(musicfile);
s.load(req);
}
private function onSoundLoaded(event:Event):void
{
//Alert.show("1");
//var localSound:Sound = event.currentTarget as Sound;
var localSound:Sound = event.target as Sound;
localSound.play();
}
]]>
</fx:Script>
<fx:Declarations>
<!-- Place non-visual elements (e.g., services, value objects) here -->
</fx:Declarations>
<!--<mx:Button id="play" label="PLAY" click="clickhandler(event)" />-->
<mx:Image id="loader1" source="@Embed(source='/opt/cloodon/site/media/img/speaker.gif')" click="clickhandler(event)" />
</s:Application>
Hello ! I'd like to create/modify the title of a pdf document using pypdf. It seems that the title is readonly. Is there a way to access this metadata r/w?
If answer positive, a piece of code would be appreciated.
Thanks
Hi StackOverflow, I've spent the past 3 hours trawling the web for answers to no avail, so I hope you can help me. I'm writing an application which automates Excel. The application has an option to "show/hide the excel sheet" so you can look at it, make any final changes and so forth.
Closing the application will naturally close the instance of Excel, however, there is a small chance that someone may exit out of Excel directly, without thinking. This breaks my application and I can't seem to find anyway of "checking if the same workbook is still open, and if not, re-opening it", before saving it
I've tried all sorts of things: checking if the Excel Application is null (when it's !=null it will save correctly, but when it "is" null (or at least, something other than !=null it won't even hit the breakpoint so I'm completely lost :(
Help please?
Are there end-of-exif / end-of-xmp / end-of-iptc / start-of-data markers that I could use to get a checksum of just the data part of a jpg / jpeg (and other image formats)?
D <- read.csv("sample1.csv", header = FALSE, sep = ",")
D
V1 V2 V3 V4
1 20100316 109825 352120 239065
2 20100317 108625 352020 239000
3 20100318 109125 352324 241065
D[,1]
[1] 20100316 20100317 20100318
In the above example how do I get the data in D[,1] to be read, and stored as date values:
2010-03-16, 2010-03-17, 2010-03-18 ? I have lots of data files in this format.
TIA,
Hi,
How do I make syncdb execute SQL queries (for table creation) defined by me, rather then generating tables automatically.
I'm looking for this solution as some particular models in my app represent SQL-table-views for a legacy-database table.
So, I've created their SQL-views in my django-DB like this:
CREATE VIEW legacy_series AS SELECT * FROM legacy.series;
I have a reverse engineered model that represents the above view/legacytable. But whenever I run syncdb, I have to create all the views first by running sql scripts, otherwise syncdb simply creates tables for them (if a view is not found).
How do I make syncdb run the above mentioned SQL?
I've looked in the page for instrutions on this, tried .out or .output extensions and filenames, but nothing works.. How I am supporte to upload the ouput?
Hey,
I have a simple "live search" (results displayed while typing) web site. This make up is Ajax to PHP querying a pretty large XML document (10,000+ lines). This is all been hosted on a local Apache server (xamp). The scale of the xml document seems to be causing huge performance issue with results taking 10ish seconds to give the results.
I'm very new to PHP (this actually being my first play about) so there below is a snippet of code in case there is something obvious
for($i=0; $i<($foodListXML->length); $i++){
$type=$foodListXML->item($i)->getElementsByTagName('type');
$foodnote=$foodListXML->item($i)->getElementsByTagName('foodnote');
$style=$foodListXML->item($i)->getElementsByTagName('style');
if ($type->item(0)->nodeType==1)
{
//find a link matching the search text
if (stristr($type->item(0)->childNodes->item(0)->nodeValue,$q)){
$currentFoodName = $type->item(0)->childNodes->item(0)->nodeValue;
$currentFoodStyle = $style->item(0)->childNodes->item(0)->nodeValue;
$currentFoodNote = $foodnote->item(0)->childNodes->item(0)->nodeValue;
if ($hint==""){
$hint= $currentFoodName . " , " . $currentFoodNote . " , <b>" . $currentFoodStyle. "</b>" . "<br>" ;
}
else{
$hint=$hint . $currentFoodName . " , " . $currentFoodNote . " , <b>" . $currentFoodStyle. "</b>" . "<br>" ;
}
}
}
}
}
Also if having the data in a DB and accessing that is faster, then I'm open to that.. All ideas really!!
Thanks.
My makefile is below
Also, I would appreciate it if you told me how to move my .class files to ../bin/
JFLAGS = -cp
JAR = "RSBot*.jar"
JC = javac
.SUFFIXES: .java .class
.java.class:
$(JC) $(JFLAGS) $(JAR) $*.java
CLASSES = \
src/Banker.java \
src/Eater.java \
src/Fighter.java \
src/grotgui.java \
src/InventTab.java \
src/Looter.java \
src/Potter.java \
src/W8babyGrotworm.java \
src/Walker.java
default: classes
classes: $(CLASSES:.java=.class)
clean:
$(RM) *.class