I got this to work. I had to set the foreground color to make the background color work (??).

So I changed:

    cellStyle.setFillBackgroundColor(HSSFColor.GREY_25_PERCENT.index);

to:

    cellStyle.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);

and it worked!

If you are setting the foreground color, use 

    cellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);

If you are setting the background color, use

    style.setFillPattern(FillPatternType.THICK_BACKWARD_DIAG);
or

    style.setFillPattern(FillPatternType.THIN_BACKWARD_DIAG);


The foreground and background colors seem to &#39;stack&#39; (red + blue = purple)  if you set the foreground fill pattern before the background fill pattern, but not the other way round. There are several other fill patterns you can choose from. Note that the color will not be applied if you do not change the default fill pattern.

`CellStyle.SOLID_FOREGROUND` is deprecated in version 3.15+. Use `FillPatternType.SOLID_FOREGROUND` instead.

csHeader.setFillForegroundColor(HSSFColor.SKY_BLUE.index);
		csHeader.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);

I really appreciate Moq&#39;s `Loose` mocking behaviour that returns default values when no expectations are set. It&#39;s convenient and saves me code, and it also acts as a safety measure: dependencies won&#39;t get unintentionally called during the unit test (as long as they are virtual).

However, I&#39;m confused about how to keep these benefits when the method under test happens to be virtual.  
In this case I *do* want to call the real code for that one method, while still having the rest of the class loosely mocked.

All I have found in my searching is that I could set `mock.CallBase = true` to ensure that the method gets called. However, that affects the whole class. I don&#39;t want to do that because it puts me in a dilemma about all the other properties and methods in the class that hide call dependencies: if CallBase is true then I have to either

 1. Setup stubs for all of the properties and methods that hide dependencies -- Even though my test doesn&#39;t think it needs to care about those dependencies, or
 2. Hope that I don&#39;t forget to Setup any stubs (and that no new dependencies get added to the code in the future) -- Risk unit tests hitting a real dependency.

What I think I want is something like:  
`mock.Setup(m =&gt; m.VirtualMethod()).CallBase();`  
so that when I call `mock.Object.VirtualMethod()`, Moq calls into the real implementation...


**Q: With Moq, is there any way to test a virtual method, when I mocked the class to stub just a few dependencies? I.e. Without resorting to *CallBase=true* and having to stub all of the dependencies?**


---

*Example code to illustrate*  
   *(uses MSTest, InternalsVisibleTo DynamicProxyGenAssembly2)*

In the following example, `TestNonVirtualMethod` passes, but `TestVirtualMethod` fails - returns null.


    public class Foo
    {
        public string NonVirtualMethod() { return GetDependencyA(); }
        public virtual string VirtualMethod() { return GetDependencyA();}

        internal virtual string GetDependencyA() { return &quot;! Hit REAL Dependency A !&quot;; }
        // [... Possibly many other dependencies ...]
        internal virtual string GetDependencyN() { return &quot;! Hit REAL Dependency N !&quot;; }
    }

    [TestClass]
    public class UnitTest1
    {
        [TestMethod]
        public void TestNonVirtualMethod()
        {
            var mockFoo = new Mock&lt;Foo&gt;();
            mockFoo.Setup(m =&gt; m.GetDependencyA()).Returns(expectedResultString);

            string result = mockFoo.Object.NonVirtualMethod();

            Assert.AreEqual(expectedResultString, result);
        }

        [TestMethod]
        public void TestVirtualMethod() // Fails
        {
            var mockFoo = new Mock&lt;Foo&gt;();
            mockFoo.Setup(m =&gt; m.GetDependencyA()).Returns(expectedResultString);
            // (I don&#39;t want to setup GetDependencyB ... GetDependencyN here)

            string result = mockFoo.Object.VirtualMethod();

            Assert.AreEqual(expectedResultString, result);
        }

        string expectedResultString = &quot;Hit mock dependency A - OK&quot;;
    }


When mocking a class with Moq, how can I CallBase for just specific methods?

I&#39;ve got a monitoring system that is collecting data every n seconds (n is approximately 10 but varies).  I&#39;d like to aggregate the collected data by 15 minute intervals.  Is there a way to consolidate the timestamp values into 15 minute chunks to allow for grouping to work?

Group mysql query by 15 min intervals

I am using POI to create an Excel spreadsheet in Java. I have the following code used for creating a header row:

    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet(&quot;Report&quot;);
    
    // some more code
    
    HSSFRow row = sheet.createRow(0);
    
    HSSFCell cell = row.createCell(cellNumber);
    HSSFCellStyle cellStyle = wb.createCellStyle();
    
    cellStyle.setFillBackgroundColor(HSSFColor.GREY_25_PERCENT.index);
    cellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
    		    		
    HSSFFont font = wb.createFont();
    font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
    font.setColor(HSSFColor.WHITE.index);
    		            
    cellStyle.setFont(font);
    cell.setCellStyle(cellStyle);

The issue I am having is that setting the fill background color on the cell always comes out black, no matter what color I pick. What am I doing wrong? If I don&#39;t use the &quot;setFillPattern&quot; line, no color shows up at all.

Setting foreground color for HSSFCellStyle is always coming out black

I am using POI to create an Excel spreadsheet in Java. I have the following code used for creating a header row:
<pre><code class="hljs language-ini">HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("Report");

// some more code

HSSFRow row = sheet.createRow(0);

HSSFCell cell = row.createCell(cellNumber);
HSSFCellStyle cellStyle = wb.createCellStyle();

cellStyle.setFillBackgroundColor(HSSFColor.GREY_25_PERCENT.index);
cellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
		 		
HSSFFont font = wb.createFont();
font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
font.setColor(HSSFColor.WHITE.index);
		 
cellStyle.setFont(font);
cell.setCellStyle(cellStyle);
</code></pre>
The issue I am having is that setting the fill background color on the cell always comes out black, no matter what color I pick. What am I doing wrong? If I don't use the "setFillPattern" line, no color shows up at all.

I know it&#39;s not possible to define a constructor in an interface. But I&#39;m wondering why, because I think it could be very useful.

So you could be sure that some fields in a class are defined for every implementation of this interface.

For example consider the following message class:

    public class MyMessage {
       
       public MyMessage(String receiver) {
          this.receiver = receiver;
       }

       private String receiver;
    
       public void send() {
          //some implementation for sending the mssage to the receiver
       }
    }

If a define an interface for this class so that I can have more classes which implement the message interface, I can only define the send method and not the constructor. So how can I ensure that every implementation of this class really has an receiver set? If I use a method like `setReceiver(String receiver)` I can&#39;t be sure that this method is really called. In the constructor I could ensure it.

Constructor in an Interface?

Is there a way in java to create a string with a specified number of a specified character?  In my case, I would need to create a string with 10 spaces.  My current code is:

    StringBuffer outputBuffer = new StringBuffer(length);
    for (int i = 0; i &lt; length; i++){
       outputBuffer.append(&quot; &quot;);
    }
    return outputBuffer.toString();

Is there a better way to accomplish the same thing.  In particular I&#39;d like something that is fast (in terms of execution).


Create a string with n characters

I am trying to type in a pair of angle brackets in Eclipse, like &quot;&lt;&gt;&quot;. However it shows up as a single quotation and a dot, like &quot;&#39;.&quot;. I tried a couple of times and found out that the angle bracket is actually located at back-slash&#39;s position.

Why is this happening? How can I change it back?

Thanks in advance.

Xi

Why is my keyboard messed up in Eclipse?

Something like the following:

ref example:

    void changeString(ref String str) {
        str = &quot;def&quot;;
    }
    
    void main() {
        String abc = &quot;abc&quot;;
        changeString(ref abc);
        System.out.println(abc); //prints &quot;def&quot;
    }

out example:

    void changeString(out String str) {
        str = &quot;def&quot;;
    }
    
    void main() {
        String abc;
        changeString(out abc);
        System.out.println(abc); //prints &quot;def&quot;
    }



Does Java have something like C#&#39;s ref and out keywords?

I have implemented a nested class in Java, and I need to call the outer class method from the inner class.
    
    class Outer {
        void show() {
            System.out.println(&quot;outter show&quot;);
        }
    
        class Inner{
            void show() {
                System.out.println(&quot;inner show&quot;);
            }
        }
    }

How can I call the `Outer` method `show`? 

Calling outer class function from inner class

I&#39;m using Apache POI 3.6, I want to read an excel file which has a date like this `8/23/1991`.


     switch (cell.getCellType()) {
    
       ...
       ...
    
       case HSSFCell.CELL_TYPE_NUMERIC:
         value = &quot;NUMERIC value=&quot; + cell.getNumericCellValue();
         break;
    
       ...
    
     }

But it takes the numeric value type and returns the value like this `33473.0`.

I&#39;ve tried to use Numeric Cell Type although with no luck.

     
    dbltemp=row.getCell(c, Row.CREATE_NULL_AS_BLANK).getNumericCellValue();

    if (c == 6 || c == 9) {
        strTemp= new String(dbltemp.toString().trim());
    
        long tempDate = Long.parseLong(strTemp);
        Date date = new Date(tempDate);
    
        strVal = date.toString();
    }
    

How can I fix my problem? 



How to read Excel cell having Date with Apache POI?

I am using `Apache POI API` to generate `excel spreadsheet` to output some data.

The problem I am facing is when the spreadsheet is created and opened, columns are not expanded so that some long text like Date formatted text is not showing up on first glance.

I could just double click the column border in excel to expand or drag the border to adjust the column width but there could be 20+ columns and there is no way I want to do that manually every time I open the spreadsheet :(

I found out (though could be wrong method) `groupRow()` and `setColumnGroupCollapsed()` might be able to do the trick but no luck. Maybe I&#39;m using it in wrong way.

**Sample Code snippet**

            Workbook wb = new HSSFWorkbook();
            CreationHelper createHelper = wb.getCreationHelper();
            //create sheet
            Sheet sheet = wb.createSheet(&quot;masatoSheet&quot;);
      
            //not really working yet.... :(
            //set group for expand/collapse
            //sheet.groupRow(0, 10); //just random fromRow toRow argument values...
            //sheet.setColumnGroupCollapsed(0, true);
    
            //create row
            Row row = sheet.createRow((short)0);
            //put a cell in the row and store long text data
            row.createCell(0).setCellValue(&quot;Loooooooong text not to show up first&quot;);

**When this spreadsheet is created, the &quot;Looooooong text not to show up first&quot; string is in the cell but since the column is not expanded only &quot;Loooooooo&quot; is showing up.**

How can I configure it so that when I open my spreadsheet, the column is already expanded???

Apache POI Excel - how to configure columns to be expanded?

Somehow I manage to create new rows between two rows in an existing excel file. The problem is, some of the formatting were not include along the shifting of the rows. 

One of this, is the row that are hide are not relatively go along during the shift. What I mean is(ex.), rows from 20 to 30 is hidden, but when a create new rows the formating still there. The hidden rows must also move during the insertion/creation of new rows, it should be 21 to 31. 

Another thing is, the other object in the sheet that are not in the cell. Like the text box are not move along after the new row is created. Its like the position of these object are fixed. But I want it to move, the same thing as I insert a new row or paste row in excel. If there is a function of inserting a new row, please let me know.

This what I have right now, just a snippet from my code.

    HSSFWorkbook wb = new HSSFWorkbook(template); //template is the source of file
    HSSFSheet sheet = wb.getSheet(&quot;SAMPLE&quot;);
    HSSFRow newRow;
    HSSFCell cellData;

    int createNewRowAt = 9; //Add the new row between row 9 and 10
    
    sheet.shiftRows(createNewRowAt, sheet.getLastRowNum(), 1, true, false);
    newRow = sheet.createRow(createNewRowAt);
    newRow = sheet.getRow(createNewRowAt);

If copy and paste of rows is possible that would be big help. But I already ask it here and can&#39;t find a solution. So I decided to create a row as an interim solution. I&#39;m done with it but having a problem like this. 

Any help will be much appreciated. Thanks!

How to insert a row between two rows in an existing excel with HSSF (Apache POI)

I&#39;ve been using Apache POI for some time to read existing Excel 2003 files programmatically. Now I have a new requirement to create entire .xls files in-memory (still using Apache POI) and then write them to a file at the end. The only problem standing in my way is the handling of cells with dates.

Consider the following code:

    Date myDate = new Date();
    HSSFCell myCell;
    // code that assigns a cell from an HSSFSheet to &#39;myCell&#39; would go here...
    myCell.setCellValue(myDate);

When I write the workbook containing this cell out to a file and open it with Excel, the cell is displayed as a number. Yes, I do realize that Excel stores its &#39;dates&#39; as the number of days since January 1 1900 and that is what the number in the cell represents.

**QUESTION: What API calls can I use in POI to tell it that I want a default date format applied to my date cell?**

Ideally I want the spreadsheet cell to be displayed with the same default date format that Excel would have assigned it if a user had manually opened the spreadsheet in Excel and typed in a cell value that Excel recognized as being a date.

How do I set cell value to Date and apply default Excel date format?

I am referencing the version 3.7 of the Apache POI and I am getting a &quot;cannot be resolved&quot; error when I do:

    import org.apache.poi.xssf.usermodel.XSSFWorkbook;

Other import statements that reference POI *DO NOT* give me errors, such as:

    import org.apache.poi.ss.usermodel.*;

Any ideas??

Cannot import XSSF in Apache POI

Guys I&#39;m currently using the POI 3.9 library to work with excel files. I know of the `getLastRowNum()` function, which returns a number of rows in an Excel file.

The only problem is `getLastRowNum()` returns a number with the count starting from 0.

So if an Excel file uses the first 3 rows, `getLastRowNum()` returns 2.
If an Excel file has just 1 row, `getLastRowNum()` returns 0.

The problem occurs when the Excel file is completely empty. `getLastRowNum()` still returns 0, so I cannot determine if the Excel file has 1 row of data, or if its empty.

So how can I detect if an Excel file is empty or not ?

Content Type	Original Author	Original Content on Stackoverflow
Question	Ascalonian	View Question on Stackoverflow
Solution 1 - Java	Ascalonian	View Answer on Stackoverflow
Solution 2 - Java	dizzy	View Answer on Stackoverflow
Solution 3 - Java	SSSS	View Answer on Stackoverflow

Setting foreground color for HSSFCellStyle is always coming out black

Java Problem Overview

Java Solutions

Solution 1 - Java

Solution 2 - Java

Solution 3 - Java

Group mysql query by 15 min intervals

When mocking a class with Moq, how can I CallBase for just specific methods?

Attributions