import java.util.Map;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.codelibs.fess.crawler.entity.ExtractData;
import org.codelibs.fess.crawler.exception.ExtractException;

/**
 * Gets a text from .xls file.
 *
 * @author shinsuke
 *
 */
public class MsExcelExtractor extends AbstractExtractor {

    /**
     * Creates a new MsExcelExtractor instance.
     */
    public MsExcelExtractor() {

        msExcelExtractor = container.getComponent("msExcelExtractor");
    }

    public void test_getText() {
        final InputStream in = ResourceUtil.getResourceAsStream("extractor/msoffice/test.xls");
        final String content = msExcelExtractor.getText(in, null).getContent();
        CloseableUtil.closeQuietly(in);
        logger.info(content);
        assertTrue(content.contains("テスト"));
    }

            assertEquals("application/pdf", mimeMap.getMimeType("pdf"));
            assertEquals("application/msword", mimeMap.getMimeType("doc"));
            assertEquals("application/vnd.ms-excel", mimeMap.getMimeType("xls"));
            assertEquals("text/html", mimeMap.getMimeType("html"));
            assertEquals("text/html", mimeMap.getMimeType("htm"));
            assertEquals("image/jpeg", mimeMap.getMimeType("jpg"));

application/access             mdf              # Microsoft Access
#application/excel              xls              # Microsoft Excel
application/vnd.ms-excel       xls              # Microsoft Excel
application/font-tdpfr         pfr              # TrueDoc Portable Font Resource
application/futuresplash       spl              # Macromedia Flash
application/hep                hep              # Hummingbird Host Explorer Profiles

    }

    public void test_getTika_msexcelx() {
        final InputStream in = ResourceUtil.getResourceAsStream("extractor/msoffice/test.xlsx");
        final ExtractData extractData = tikaExtractor.getText(in, null);
        final String content = extractData.getContent();
        CloseableUtil.closeQuietly(in);
        logger.info(content);

        final AtomicBoolean streamClosed = new AtomicBoolean(false);

        try (final InputStream originalStream = ResourceUtil.getResourceAsStream("extractor/msoffice/test.xls")) {
            final InputStream trackableStream = createTrackableInputStream(originalStream, streamClosed);
            final ExtractData result = extractor.getText(trackableStream, null);

            assertNotNull(result);

    <_comment>Office Open XML Workbook (macro-enabled)</_comment>
    <glob pattern="*.xlsm"/>
    <sub-class-of type="application/x-tika-ooxml"/>
  </mime-type>

  <mime-type type="application/vnd.ms-excel.sheet.binary.macroenabled.12">
    <_comment>Microsoft Excel 2007 Binary Spreadsheet</_comment>
    <glob pattern="*.xlsb"/>
    <sub-class-of type="application/x-tika-ooxml"/>
  </mime-type>

- JUnit 4.x
- DBFlute UTFlute (PlainTestCase)
- Apache POI (for MS Office tests)
- Apache Commons Compress (for archive tests)

### Test Resources:
- `extractor/msoffice/test.doc`
- `extractor/msoffice/test.xls`
- `extractor/msoffice/test.ppt`
- `extractor/test.txt`
- `extractor/zip/test.zip`

## Key Improvements Tested

### 1. Resource Management
- ✅ Try-with-resources usage in MS Office extractors

    }

    @Test
    @DisplayName("Test getFileName returns correct value")
    void testGetFileName() throws SMBProtocolDecodingException {
        String expectedFileName = "important_document.xlsx";
        byte[] buffer = createValidNotificationBuffer(expectedFileName, FileNotifyInformation.FILE_ACTION_ADDED);

        notifyInfo.decode(buffer, 0, buffer.length);

    // public ResponseData call() throws Exception {
    // String[] urls =
    // new String[] {
    // "http://.../",
    // "http://.../test.pdf",
    // "http://.../test.doc",
    // "http://.../test.xls",
    // "http://.../test.ppt",
    // "http://.../test.txt", };
    // for (String url : urls) {
    // ResponseData responseData = httpClient.doGet(url);
    // // assertEquals(200, responseData.getHttpStatusCode());