Read data from Google Spreadsheet without authentication using Java

Google Spreadsheets provides a way to create, edit, save spreadsheets online.
The Google Sheets API (formerly called the Google Spreadsheets API) lets you develop client applications that read and modify worksheets and data in Google Sheets.
Read More about Sheets API

Let's see how to use this API to read data from Spreadsheet, here i am going to use Spreadsheet version 3.0 , if this link doesn't work then check on GitHub , from here you will get  client library for all Google APIs

Reading html source of a webpage (url) using Oracle ADF (af:richTextEditor) & Java

This post is about a common question asked in java-

How to read page source of a website ? or how to get html source of an url?

so for that there is a simple piece of code to read html source of a webpage using it's url, and i have added  af:richTextEditor (ADF Faces component for ricj text formatting) to show html form of url source

• I have a page with one input text to capture url entered by user, a button to fetch html source of that webpage and a af:richTextEditor to show source code in editing mode and in html mode 
  





• See how to get webpage source from an url using java and save it to a html file (download a webpage ), Bind inputText and richInputText to managed bean and craete a actionListener on button to get source



    // Input text Binding to get URL
    private RichInputText webPageUrlBind;
    // RickInput text Binding to set Source
    private RichTextEditor richTextBind;
    public void setWebPageUrlBind(RichInputText webPageUrlBind) {
        this.webPageUrlBind = webPageUrlBind;
    }

    public RichInputText getWebPageUrlBind() {
        return webPageUrlBind;
    }

    public void setRichTextBind(RichTextEditor richTextBind) {
        this.richTextBind = richTextBind;
    }

    public RichTextEditor getRichTextBind() {
        return richTextBind;
    }
    /**Method to get html source of url (webpage) and set this to rickTextEditor
     * @param actionEvent
     */
    public void getSourceCodeAction(ActionEvent actionEvent) {
        URL url = null;

        try {
            if (webPageUrlBind.getValue() != null) {
                // Define your URL- Get value from input text using binding
                url = new URL(webPageUrlBind.getValue().toString());
            }
            URLConnection conn = url.openConnection();

            // open the stream and put it into BufferedReader
            BufferedReader br = new BufferedReader(new InputStreamReader(conn.getInputStream()));

            String inputLine;
            String sourceCode = "";

            //Save html file (HTML Source Code of given URL)
            String fileName = "D:/web-content.html";
            File file = new File(fileName);

            if (!file.exists()) {
                file.createNewFile();
            }

            //use FileWriter to write file
            FileWriter fw = new FileWriter(file.getAbsoluteFile());
            BufferedWriter bw = new BufferedWriter(fw);
            System.out.println("Printing WebPage source on console, Please wait...\n");
            while ((inputLine = br.readLine()) != null) {
                System.out.println(inputLine);
                bw.write(inputLine);
                sourceCode = sourceCode.concat(inputLine);
            }

            bw.close();
            br.close();
            richTextBind.setValue(sourceCode);
            AdfFacesContext.getCurrentInstance().addPartialTarget(richTextBind);
            System.out.println("\n\nYour file is save in D drive! Congratulations ");

        } catch (MalformedURLException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }

    }






• now click on button and see , here i am getting source code of this blog http://oracleadf-java.blogspot.in/





• now switch RichTextMode to see html preview of this source, it is exactly looking like live webpage, it shows one can practice in this ADF Faces's rickTextEditor to learn html tags





• and see in D drive of your system a file named web-content created , it contains whole source of this webpage

 Cheers - Happy Learning :)