UP Computer Science Interns' Blog

May 31, 2010

Memories of UNILAB Day 3-5

Filed under: unilab_200575808 — undyingfenix @ 8:40 am

This is about Day 3-5 of my internship in UNILAB Consumer Health. My program has started to copy data from the original excel file to the new excel file. However, the data being copied was the whole worksheet, and I only needed specific parts from the original excel file. This led to another search in the knowledge database and in the various tutorials that are offered in the internet.  I found some tutorials that said I had to name the range in Excel, but I couldn’t find this function in Excel 2007. Also, since this solution needed additional user input, which I was trying to avoid, I had to find another solution for my problem. Finally, after more digging in the internet I finally found what I wanted! This was the code:

Select * from [sheet_name$range1:range2]

I tested this code, played around with it, and finally I found a way to extract specific ranges in excel!


2 days to go! (gym) >.<

Filed under: chikka_200746372 — trollolololl @ 8:28 am
Tags: , , , ,

may24/monday: Sir Joel gave us another project, pretty much the same as the first one, but with an additional feature. Since my partner Aica’s already gone (huhu ;_; ) the three of us will be working together.


Chikka Week #7b — Farewell Parties

Filed under: chikka_200656900 — bernardojr @ 2:16 am

Is it possible for a day to be happy and sad at the same time?

Clockwise from top:  sir Joel, me, Diel, Iehl


« Previous PageNext Page »

Create a free website or blog at WordPress.com.