Showing posts with label software engineering. Show all posts
Showing posts with label software engineering. Show all posts

May 22, 2015

To create a shared excel sheet for multiple user access at real time


How to share an excel that helps multiple user to edit same time

I need an excel sheet , where multiple users ( class 4 employees ) can post mark list of students to an excel in my office, where higher officials need to check the result entered is correct or not whereas other staffs need to download the result before publishing. All the works has to done simultaneously. here is a solution for such issues. Over usage of styles will hang the file. If two users edit the same cell, the excel asks who's data to be saved while saving the document. If two users try to save the shared excel at same time, the file will be locked, the only thing you can do at this situation is to wait until the other person saves Or wait for some times the issue will be solved.



Share workbook Option is available in Review Tab.

Click on Share

Excel Share
Sharing in Excel


Check the option Allow changes by more than one user at the same time.

Once you shared the excel sheet and multiple user starts working on it, Here you can see the users who are working on the excel workspace.



Multiple user access excel
Allow sharing mode in excel


Click ok to share the excel


Excel Share
Share Excel Workspace


Track changes

To track changes made by all users use the following steps, go to track chages option in review tab, check the option when, who, where, List changes on a new sheet

shared excel track changes
Track chages in an excel


Posted by +belazy


http://javabelazy.blogspot.in/

March 07, 2013

Regional Office - Consumerfed Information Technology Section Kozhikode


Consumerfed Regional office kozhikode Region IT Section




സീസണൽ റിപ്പോർട്













സീസണൽ റിപ്പോർട്







Contact us @ 8281808025/9



January 07, 2012

How to use string object in switch case

How to use string object in switch case


/**
* In Java SE 7 and later, you can use a String object in the switch statement’s expression
* Here is a small example
* If the string is null , it will throw a nullPointerException
* This is not the Best Java Programing Blog, I am just a learner in java
* Download jdk1.7 or above
*/
package com.nick.Switch;
import java.util.Scanner;
/**
* @author Oscar
*
*/
public class SwitchCaseString {
/**
* @param mon : denotes the first 3 char of month entered by the user
* @return month name
*/
private String getMonthName(String mon) {
String month = null;
switch (mon.toUpperCase()) {
case “JAN”: month =” its January “;
break;
case “FEB”: month =” its February “;
break;
case “MAR”: month =” its March “;
break;
case “APR”: month =” its April “;
break;
case “MAY”: month =” its May”;
break;
case “JUN”: month =” its June “;
break;
case “JUL”: month =” its Jully “;
break;
case “AUG”: month =” its August “;
break;
case “SEP”: month =” its September “;
break;
case “OCT”: month =” its October “;
break;
case “NOV”: month =” its November “;
break;
case “DEC”: month =” its December “;
break;
default:
month =” INVALID “;
break;
}
return month;
}
public static void main(String[] akshara) {
SwitchCaseString instance = new SwitchCaseString();
System.out.println(” Enter the first 3 character of the month “);
System.out.println(instance.getMonthName(new Scanner(System.in).next()));
}
}


Switch case example for practical question ( lab exams) 
Thanking you

Facebook comments