Click here to Skip to main content
15,890,609 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
have written a code which retrieves latest tweets of a particular user and display it in an excel sheet. I want to display more than 20 tweets and went about reading many online available help but was not useful. Can any one help me out?

TwitterServlet.java:

package com.dhruvil.jsw;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import twitter4j.Status;
import twitter4j.Twitter;
import twitter4j.TwitterException;
import twitter4j.TwitterFactory;
import twitter4j.auth.AccessToken;




public class TwitterServlet extends HttpServlet {
private static final long serialVersionUID = 1L;


public TwitterServlet() {
super();
}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String CONSUMER_KEY = "xxx";
request.setCharacterEncoding("UTF-8");
String CONSUMER_KEY_SECRET = "xxx";
String AccessToken = "xxx";
String AccessTokenSecret = "xxx";
response.setContentType("text/html");
response.setContentType("application/PDF");
String input1 = request.getParameter("first");

System.out.println(input1);
if (input1 == null || input1.trim().length() == 0) {
input1 = "You didn't enter any text.";
}
XSSFWorkbook workbook = new XSSFWorkbook();

XSSFSheet sheet = workbook.createSheet("Twitter Sheet");




try{
Twitter twitter = new TwitterFactory().getInstance();
twitter.setOAuthConsumer(CONSUMER_KEY, CONSUMER_KEY_SECRET);
AccessToken oathAccessToken = new AccessToken(AccessToken, AccessTokenSecret);
twitter.setOAuthAccessToken(oathAccessToken);
List<status> status = twitter.getUserTimeline(input1);
List<string> tweets = new ArrayList<string>();

for (Status status2 : status)
{
tweets.add(status2.getText());
System.out.println("---Tweet---"+status2.getText());
}

WriteExcel.writeExcel(tweets, "Tweets.xls");





}catch (TwitterException te){
System.out.println("Error occured "+te);
}
System.out.println("Tweets Retrieved");



super.doPost(request, response);
}

}

I can retrieve 20 tweets and can display in an excel sheet. How to get more tweets and have a pop up in which the excel sheet gets automatically opened with data in it
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900